combo box

D

davidhull

Hi just a query guys

i have a problem i have a form which contains information about devices with
DeviceID as the primary key. This ID is the identifier i want to use
there is a sub-form within this that contains a Name combo box with names of
employees and a DateNotUsed field

i want another form to take the values from this
if i choose a name from the combo box in this other form i want the DeviceID
field to display the relevant device IDS relating to that person WHERE the
DateNotUsed field is blank NULL
 
Top