A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Running & Setting Up Queries
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

How do I create a lookup parameter query in Access? (e.g. Find x)



 
 
Thread Tools Display Modes
  #1  
Old July 3rd, 2005, 01:18 PM
Graeme at Raptup
external usenet poster
 
Posts: n/a
Default 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  
Old July 3rd, 2005, 03:04 PM
Jeff Boyce
external usenet poster
 
Posts: n/a
Default

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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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 06:10 AM
Lookup fields - what's wrong with them? NATHAN SANDERS New Users 2 May 4th, 2004 10:51 AM


All times are GMT +1. The time now is 10:44 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.