If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How do I create a lookup parameter query in Access? (e.g. Find x)
I'd like to create a "search" type query similar to those you'd find on a
website with a drop-down list. The field in question is a lookup in the form but I want the user to be able to select from a drop down list in the parameter query prompt. Maybe there's another way to reach the same objective? Either way, help would be much appreciated. |
#2
|
|||
|
|||
Graeme
Parameter queries only allow for the popup [Enter your value here] approach. However, if you create a form with a combo box that gives the choices, you can modify your parameter query to look at the form's combo box to get its search criterion. Use something like (your syntax may vary): Forms!YourNewFormName!cboYourComboBoxName in the selection/criterion row under your field in your query. -- Good luck Jeff Boyce Access MVP "Graeme at Raptup" Graeme at wrote in message ... I'd like to create a "search" type query similar to those you'd find on a website with a drop-down list. The field in question is a lookup in the form but I want the user to be able to select from a drop down list in the parameter query prompt. Maybe there's another way to reach the same objective? Either way, help would be much appreciated. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Parameter Query to Data Access Page | Red | Running & Setting Up Queries | 0 | June 30th, 2005 01:46 AM |
Data Access Page from parameter Query | jackle | Running & Setting Up Queries | 1 | June 19th, 2005 05:01 AM |
Why is a French Spellchecker a "required" update for English speak | French Spellcheck Required? | General Discussion | 23 | April 26th, 2005 01:17 AM |
What is the difference between 2002 and 2003? | Red Sonya | General Discussion | 2 | March 1st, 2005 05:10 AM |
Lookup fields - what's wrong with them? | NATHAN SANDERS | New Users | 2 | May 4th, 2004 10:51 AM |