help on parameter

[tonymat]

I need a new parameter in my query which enables me to select from a field in the table rather than typing .

 

[statsman]

If I understand your problem correctly, you are currently using a parameter in your query that allows you to enter the parameter by typing in the value you want the query to find.

You can change the parameter by opening the query in design view, removing the "type in" prompt and changing the criteria to the specific value you want the query to find.

Example:
Old way - a box appears asking you to enter the value, lets say "ABC"

New way - remove the prompt from the criteria and replace it with "ABC"

This will find only those values in the specific field that are "ABC"

The problem with this is that if you have 17 different values in the field you are searching, you require 17 different queries.

IF I DID NOT UNDERSTAND YOUR PROBLEM CORRECTLY and you wish to use a parameter with a type in value then:
Open the query in design view.
In the criteria of the field you wish to search place [Enter data to search for:] (square brackets required - the text could be anything).
When you open your query, you will be prompted for the value you want. Type it in and the query will search for that specific data.

Hope this helps.