Combo boxes

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form with a combo box on it it is set to look up a record. all this works fine except being based on a table the list gets very long. (call it Property list) it looks up the names of buildings

I would like to have a second combo or list box (Call it Department as it has all the departments that the buildings belong to) that would allow the record selection combo to only list items appropriate to the selection selection of the second combo box. I have set up a second combo which works fine am triing to set that as the criteria for a querie that will select based on results in the second combo. Thus far with no success. the quire works but not the property combo

I would be grateful for any hel

Kind Regards

Morgan
 
Morgan,

Make the department combobox the criteria of department in the property
combobox. In the afterupdate event of the department combobox, requery the
property combobox.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com



Morgan said:
I have a form with a combo box on it it is set to look up a record. all this
Click to expand...
works fine except being based on a table the list gets very long. (call it
Property list) it looks up the names of buildings.
I would like to have a second combo or list box (Call it Department as it has
Click to expand...
all the departments that the buildings belong to) that would allow the record
selection combo to only list items appropriate to the selection selection of the
second combo box. I have set up a second combo which works fine am triing to set
that as the criteria for a querie that will select based on results in the
second combo. Thus far with no success. the quire works but not the property
combo.
 
Back
Top