Use of a list box to set the criteria

[volorgas]

My database records information about old houses that were published in several different pattern books. One field in the table records the published design number for each house record, while another field contains a list box of the titles of the different pattern books. My problem is that design # 12 from one pattern book title is not the same as design #12 from another pattern book title. Therefore, I have a query that I created for use in providing data to a report. The query asks the user for two pieces of information to be used for criteria to select the appropriate data to be returned. The first piece of information is the design number which the user enters by keying in the appropriate value in the dialog box that pops up. The second piece of information needs to be a selection of the appropriate pattern book title for the list box of choices contained in the field of the table. How can I setup my query to show the user this listbox of choices, so that once the selection is made the query returns the proper results?

 

[ajetrumpet]

you cant show listboxes in the query, but you can query by form, which means you reference the listbox in the WHERE clause of the statement, and run the query from a button on the form.

 

[pbaldy]

For a report, I do this type of thing:

http://www.baldyweb.com/multiselect.htm

 

[volorgas]

I just learned that the listbox I was referring to is actually a query to a seperate table containing the list of publication titles. Would this situation make my request any easier?

 

[pbaldy]

I don't think it changes anything. You still need to get the selected items.