How do I enter multiple inqueries within a popup search box?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a query that has the following phrase in the Criteria Field: Like
[Enter a State]

How could I enter multiple entries into this popup search box, and have the
query pull every specified record for each entry? For example, if I want to
look up California, Delaware, Idaho, and Alabama, how can I look these up
together instead of having to enter each state seperately and run the query?
 
Build a table with your a field for your items (States) and a Yes/No field.
Create a form in datasheet with a textbox for item and checkbox for Yes/No
field. Set the Scroll Bars - Neither,Record Selector - No, Navagation Buttons
- No, and Dividing Lines - No.
Load the the form as a subform without links. Add a command button to run
query. Add an event to run an update query to uncheck the states on close of
form.
In your query add the table but do not join. Use the Yes/No field as an
output field. Use -1 (minus one) as criteria for the field. Use the textbox
as criteria for your states field.
Individual checks which state is wanted. They click the command button.
When the query is run it pulls a list of states that are checked.
 
Back
Top