I have a form set up using multipe combo boxes to define my parameters for a query and subsequent report. my question is how to set it up such that all records can be printed if no selection is made in a combo box.<br><br>(ie. if i choose a selection in the first box but leave the next one alone how can i make it such that all of the options determined by the second box are included in my query)<br><br>did i confuse you?? i think i confused myself!!! any insights would by greatly appreciated!!!!!!!
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Parameter Query using a combo box - question
- Thread starter Kyosa
- Start date
Guest_imported
New member
- Jan 1, 1970
- 0
one simple way.<br> in the query put Like IIf([forms]![yourform]![combo#] = "",IIf([forms]![yourform]![combo#] ,"*"
<br>may need to play with the syntax
<br>may need to play with the syntax
Guest_imported
New member
- Jan 1, 1970
- 0
Like IIf([forms]![yourform]![combo#] = "",[forms]![yourform]![combo#] ,"*"<br><br>Sorry had an extra IIf in the first post<br>
<br><br>Sorry had an extra IIf in the first post<br>- Thread starter
- #4
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question