Multiple criteria for a query

[Liam87]

I was wondering if anyone would have an idea to list values in a form which set values for criteria in a query.


I think you would use In(X, Y, Z) in the criteria field, however I want to use a form so a user can enter in a set of values they want to restrict the query too.

As an example you have a list of Cars and Occurences in your 5km raidus, the user can enter into the form Car1, Car2, Car3 and the query will give the occurences of those 3 cars.

[orange]

I think you will be building a form, and on the form you may have some controls. Your user could select 1 or more options from that control.(could be a multiselect list box) Once the user has made all of his/her selections, you would use vba and the selections that were made to create a query. Then perhaps on another control(button) in the Click event, you would execute the query you built and display the resulting info on a form.

Just one scenario, if I've understood your question correctly. I don't know your experience level so can't be more specific.

There are a number of examples listbox selections and mixing SQL and vba at
http://www.fontstuff.com/access/acctut11.htm