Searching for a record

[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.

 

[Steve]

Why do you say you can only use one box for the search?

 

[Guest]

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.