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

parameter queries

P: 18
When setting up a parameter query is it possible for the parameter dialogue box to have a combo or list box, so that a restricted reply can be entered? If so, how would I do it?
Oct 18 '06 #1
Share this Question
Share on Google+
3 Replies


P: 19
Rather than have the parameter in the query, create an unbound form and add a combo box control to the form. In the rowsource property of the combo box, make this the table that you are getting the data from (whatever table your query is looking at). If you now open the form, the combo box will contain the data on the table. You can use this combo box to select data from the query, by replacing your parameter in the query with the name of the combo box on the form - instead of [Enter Value], it will be something like [Forms]![Form1]![Combo1].

The result of the query will now be based upon what you select from the combo box.
Oct 19 '06 #2

P: 18
Rather than have the parameter in the query, create an unbound form and add a combo box control to the form. In the rowsource property of the combo box, make this the table that you are getting the data from (whatever table your query is looking at). If you now open the form, the combo box will contain the data on the table. You can use this combo box to select data from the query, by replacing your parameter in the query with the name of the combo box on the form - instead of [Enter Value], it will be something like [Forms]![Form1]![Combo1].

The result of the query will now be based upon what you select from the combo box.
Thank you birchw for your information, that has worked a treat. Just one thing, as I am creating this data base for others to use, how can I change what the parameter dialogue box now says ie. form!frmCombo!Combo6. I would like it to say "Enter Course Number"
Oct 22 '06 #3

P: 19
To change the name of the combo box, just change the Name property of the combo box to EnterCourseNumber (try not to use spaces for field names).

If you want Enter Course Number to appear on the form, just edit the label and change the Caption property.
Oct 24 '06 #4

Post your reply

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