Prompt in a query

[mrtroy]

How do I create a prompt in a query that allows the user to select the value from a list?

T

 

[smedvid]

Build a user interface... a simple form that has the selection criterion and a go button to create the query. htwh,

Steve Medvid
"IT Consultant & Web Master"

http://www.saveourfarm.com

Chester County, PA Residents
Please Show Your Support...

 

[needcoffee]

If you are using Design View in the query, put a variable name in brackets on the criteria line below the field you want to select from.

i.e.
[Enter Start Date]

This will appear when the query is first started. In SQL after your WHERE

(tblname.fieldname)=[Enter Start Date]

needcoffee