Searching for a record

  • Thread starter Thread starter Helpme
  • Start date Start date
H

Helpme

I have 6 combo boxes that pull data from a single table,
however only one box can be used to search. How would I go
about creating an event procedure so that when the user
clicks on search, it uses whichever combo box has data in
it?

Thanking you in advance.
 
I have set up the form so that only one field will contain
data, so when you select data in combo box 1... 2,3 & 4
are blanked out. This ensures that only one record is
matched.
 
Back
Top