Simple Query Question

[Walshie1987]

Hi, Sorry i know this is going to be a really simple question, just i've been working on a DB all day and my minds suddely gone blank!

I have a search query and two combo boxes, i select the critria in my combo boxes, click search and the list of records matching the required criteria is displayed, that bit works fine.

But, what i also want to happen, is if one of the boxes is blank i want the DB to just search for the records matching the criteria in the other combo box.

e.g/
If both boxes have data in them:

Combo1 = John, Combo2 = Smith, click search, all records matching John Smith are displayed

then if combo1 = blank:

Combo1 = Blank, Combo2 = Smith, click Search, all records matching Smith are displayed

Hope this is clear

Cheers
Chris

 

[traingamer]

See thread701-1100527 among many other threads and faqs.

Greg
"Personally, I am always ready to learn, although I do not always like being taught." - Winston Churchill