Queries - criteria show list of values to pick from

[Mary]

In Design View - I am building an Enter Perameter Value option for the user
to pick in the value. Example [Enter Division:]. However, I want the user
to be able to pick from a list of values for this field. Is this an option?
If so how do I build that in the Criteria?

 

[KARL DEWEY]

Use a form with a list box and a command button to run query or open form
that has the query as source.
In the query use criteria like this --
[Forms]![YourFormName]![ListBoxName]

 

[Mary]

The list is in a table already - as a look up list. If I want the criteria
to prompt the user for a value in that table could I put
[tables]![tablename]![fieldname]? If so, will this prompt the user with a
drop down list. I tried this and it went straight to my next two criteria
prompts and skipped this one?? PS Thanks for your help!

Use a form with a list box and a command button to run query or open form
that has the query as source.
In the query use criteria like this --
[Forms]![YourFormName]![ListBoxName]

--
KARL DEWEY
Build a little - Test a little

In Design View - I am building an Enter Perameter Value option for the user
to pick in the value. Example [Enter Division:]. However, I want the user
to be able to pick from a list of values for this field. Is this an option?
If so how do I build that in the Criteria?

 

[KARL DEWEY]

could I put [tables]![tablename]![fieldname]?
No.

Did you do as I suggested - creating a form with listbox for user to select
from?
It sounds like you did not.
--
KARL DEWEY
Build a little - Test a little

The list is in a table already - as a look up list. If I want the criteria
to prompt the user for a value in that table could I put
[tables]![tablename]![fieldname]? If so, will this prompt the user with a
drop down list. I tried this and it went straight to my next two criteria
prompts and skipped this one?? PS Thanks for your help!

Use a form with a list box and a command button to run query or open form
that has the query as source.
In the query use criteria like this --
[Forms]![YourFormName]![ListBoxName]

--
KARL DEWEY
Build a little - Test a little

In Design View - I am building an Enter Perameter Value option for the user
to pick in the value. Example [Enter Division:]. However, I want the user
to be able to pick from a list of values for this field. Is this an option?
If so how do I build that in the Criteria?