Mutiselect in query

[Guest]

Is it possible to created a query that will prompt users to select query
criteria from a combo box or list when executing a query. If so, how is this
accomplished.

 

[Tom Coffinger]

The basics of it are

create a form with the combo box
in the query criteria line, right click and go to the builder
navigate to the form.combobox
click ok.

now, what ever value the combobox is, is the criteria for the query

 

[Guest]

How can I set it up so that the form is launched whenever the query is
excuted so that the user can pick from the values?

 

[Guest]

Hey DV

Its the other way around just like tom wrote, CREATE A FORM, there you put a
combo box where the data (see properties) is selected from the tablefield
that you want the user to select from, then go to the event fields and select
"on update" and in the wizard select the open query function. Then you go to
the query start the builder on the field where the selection was made and
navigate to the combox box
the value in the criteria field should be some thing like this:
[Forms]![Start Pagina]![Combo54]
Then the query will display the results in a table view, however you can do
it in a more end-user friendly way by changing this select query in to a
create table query to a "temp" table and in the event procedure just under
the line that state
DoCmd.OpenQuery "query name" (existing line)
adding following line
DoCmd.OpenForm "form name" (to be added)
where "form name" stands for the form you created refering to the data in
the "temp" table.

best regards