If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Using form for a query
I'm using a form to set parameters for a query, and eventually a report. I
want to query for all shipments going to a specific city, selected from a combo box. This works fine if I ask the query to look back at the form for the destination criteria. However, I want users to be able to select a wildcard-type selection that would have the query run for all destinations. I've tried using a blank and * to no avail, so I'm guessing I will need to build a SELECT string to pass along as part of the DoCmd, but I don't know how to do this. Can someone please help? |
Thread Tools | |
Display Modes | |
|
|