giving a query a parameter by a user prompt

[bear]

Is there a way in access to get a query to ask you for a parameter, and then select the data based on that parameter?
Basically, I have a table which holds records of every photograph that I index. Each photo is grouped into a "set number", along the same lines as a roll of film. I want to be able to run a query that will bring together all the records for a specific set number, so that they can then be printed through a report. The set numbers take the format 000. I'm kind of familiar with the expression builder, and queries in design view.

 

[Andrew Fergus]

Hi, if you go into your query design, in the criteria section under the "set number" enter something like this :

=[Enter Set Number]

When you run the query (or open the report that is based on the query) a small message box will appear asking "Enter Set Number". Whatever number you enter is then the criteria for that query.

HTH, Andrew.

 

[bear]

Great! That works fine!