p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   Access (http://p2p.wrox.com/forumdisplay.php?f=18)
-   -   Access: Drop down list in query (http://p2p.wrox.com/showthread.php?t=39110)

newtoaccess February 27th, 2006 04:03 PM

Access: Drop down list in query
 
I am running a query in Access. In the criteria section I added a prompt for a dialog box in square brackets (like this- [enter name]). I want to change this dialog box to one that will allow the user to select the name by clicking on a drop down list. How can this be done? Greatly appreciate your help.

Newtoaccess


mmcdonal February 28th, 2006 08:30 AM

What you need to do is to create a form with the combo box on it that selects the name, then either use a button on the form to run the query, or trigger the query from the combo box's after update event. I don't think you can use a combo box from a query parameter prompt. But it won't make any difference to the user anyway.

Just have the button that launches the query launch the form with the combo box instead. Then replace the criteria in the query with [Forms]![frmNewForm].[cboYourComboBox]

HTH


mmcdonal


All times are GMT -4. The time now is 09:27 AM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.