Adding a prompt to ask for value

[MayaMana]

So I know the answer is probably very obvious I just haven't found it yet. I have a report shooting off of the main table and other reports off of queries. They hold the same information so that part isn't really important. However I would like for when one of the reports is opened to ask for a value to be entered in so that it will pull up only that record. Any advice is welcome thanks.

 

[VilaRestal]

You create a query with a parameter (message). Something like:

SELECT * FROM Table1 WHERE Field1 = [Please enter the record you wish to view here:]

Then save that query and set it as the record source of the report.

Change Table1 and Field1 to the correct table and field name.

If the report is already based on a query then you need to add the same sort of 'WHERE Field = Parameter' (or 'AND Field = Parameter' if it already has a WHERE condition).