How to show only one record in a report

[stew561]

I trying to find out what the syntax is to only show a single record in a report. I would like a pop-up to ask the person to enter a single record number for a report. It then would only show that record on the report and nothing else.

Thanks for you help,


Stew

 

[llkhoutx]

Generate the popup for the criteria, prior to opening the report. Use that popup criteria to modify a query which is the recordsource for the report. Open the report on the popup's on close event.

 

[stew561]

Generate the popup for the criteria, prior to opening the report. Use that popup criteria to modify a query which is the recordsource for the report. Open the report on the popup's on close event.

Can you creat a criteria for a report that is not based off a query?

 

[llkhoutx]

A report's recordsource can be based unpon any kind of query except a delete query, a table (of course), or it can be unbound.

 

[ronculbert]

show only one rcord for report

1. Create a query that includes all the fields of info that you have on your report.

2. In the record number column "Criteria" area type [Enter the the record number].[]

3. Save your query with whatever name you would like. Example qryRecordSearch.

4. Set your reports record source to the query you just created.

5. Create a new macro with what ever name you would like. Example
macRecordSearch.In the action section choose OpenReport and in the report name area chose the name of your report. In the filter name area insert the name of the query you created. qryRecordSearch

6. On your switch board use the button wizard to create a button that will run the macro you just created.

When the user clicks the button a message box will apear prompting the user to "Enter the record number". When the user enters the record number the report for that record number will be displayed.

Hope this is what you were looking for!