View Single Post
  #2 (permalink)  
Old February 28th, 2006, 08:30 AM
mmcdonal mmcdonal is offline
Friend of Wrox
Points: 9,611, Level: 42
Points: 9,611, Level: 42 Points: 9,611, Level: 42 Points: 9,611, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2004
Location: Washington, DC, USA.
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

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
Reply With Quote