Query Popup

  • Thread starter Thread starter Wanda via AccessMonster.com
  • Start date Start date
W

Wanda via AccessMonster.com

I have a query where I've placed brackets [Type Area Name] in the criteria
section to get the standard popup so that the user can enter a name. This
name is actually a drop-down field on my table. Is there a way to have this
standard popup be a drop-down instead of a text box in my query??

Thanks,
Wanda
 
No. You can build a form and include a dropdown, then you can reference
that form in your query. You could add a button to the form that runs the
query.
 
Unfortunately Rick B is correct. But buy the book "Access 2003 VBA
Programmer's Reference" (Wrox pub)-- it has a great section on "invisible"
custom queries.

Randall Arnold
 
Wanda said:
I have a query where I've placed brackets [Type Area Name] in the criteria
section to get the standard popup so that the user can enter a name. This
name is actually a drop-down field on my table. Is there a way to have this
standard popup be a drop-down instead of a text box in my query??

Thanks,
Wanda
Click to expand...
Take out the criteria and the drop down arrow will appear in the field if you
have that field set as a lookup field in the table.
 
Back
Top