pull down menu query

[Guest]

I need to create a query where TABLE A would have a LOCATION field where
there is more than one record that contains the same date in the LOCATION
field. TABLE B would be just a list of unique locations.

I want a Query that ASKs ( based on TABLE B) for a location and the query
would spill out the data in TABLE A that only had that LOCTION field.

Anyone knows how to do it?

 

[John Spencer]

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


A brief quote from an 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!

Quoting John Vinson

Keywords: Parameter Queries

If you need to create the unique list, you could just use
SELECT Distinct Location FROM TableA
as the source for the combobox.