Parameter Query Lookup

[Denise]

When a prompt asks for the "Company Name", I want to be able to select from a
list rather than type in the name.

Any suggestions? What do I put in the criteria? or in the Parameter Query
to accomplish this.

Thanks.

 

[Duane Hookom]

IMO, there is no good use of parameter prompts in any user interface.
Consider using forms with controls for all user interaction. A combo box on a
form should meet your needs.

 

[John Spencer]

Check out this article for a detailed discussion.
http://www.fontstuff.com/access/acctut08.htm

Or check out this from MS
http://office.microsoft.com/en-us/access/HA011730581033.aspx

Or for another example
http://allenbrowne.com/ser-62.html

A brief quote from a John Vinson (Access MVP) posting.

You'll need to create a small unbound Form (let's call it frmCriteria) with a
Combo Box control (cboCrit) on it. Use the combo box wizard to select the
table for the selections, and be sure that the bound field of the combo is the
value you want to use as a criterion. Save this form.

Now use

=[Forms]![frmCriteria]![cboCrit]

as the criterion in your Query.

It's convenient to base a second Form or Report on the resulting query to
display the results; if you put a button on frmCriteria to launch that form or
report, the user can enter the criterion and view the results in one simple
operation!

End quote

Keywords: Parameter Queries, comboboxes

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County