Access Query Critera, select from a table

[debeq]

I am trying to set up a query to create a popup box when it is run that has a combo box in it so that the user can choose the critera from a table that have already set up. (In this case it is a list of names). I cannot seem to get this done, and I am not very good at coding, and cannot find a wizard or a help article for this, although I would think that there would be. I am using Access 2000.

Any ideas?

Thanks,

DB.

[nico5038]

The regular approach is to define a parameter and let the user enter the value at runtime. This parameter popup can't handle a combobox.

One option you have is to create a form with a combobox and use the value of that combobox in the query as the input for the criteria.
Another option would be to add a "SelectYN" field to the table the combo's based on and let the user set this field for the entrie(s) he wants to see. This will allow multiple selections and for the query a simple JOIN with this table and a test for the "SelectYN" field to be True.

Idea ?

Nic;o)