Select all by default for query from form.

Hey Folks,

I have a form with five combo boxes on it and one button, when each combo box has an option set and I hit the button, it runs a query which looks up the values of the form items and gives me my chosen information.

However, if these fields are: FirstName, Surname, State, Town and Road, and I want to only select on 4, 3, 2 or 1 of these - it gives me nothing.

So how do i specify that if the combo box is left blank just to select all.

So by putting data only into FirstName, say Eric, it will select ALL Surnames, states, towns and roads where the firstname is Eric.

Hello dickohead!

Look at "Demo3ComboA2000.mdb".
I made it with 3 combo, adapt it on 5 combo as you need.
Dbl click on command button reset to all.

Thank you! It was the "Like [Forms]![frmMain]![cmbName]" bit in my query that I didn't have. I had [Forms].[frmMain].[cmbMain].

Cheers mate!