By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,454 Members | 2,629 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,454 IT Pros & Developers. It's quick & easy.

Access Query Critera, select from a table

P: 1
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.
Oct 11 '07 #1
Share this Question
Share on Google+
1 Reply


nico5038
Expert 2.5K+
P: 3,072
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)
Oct 11 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.