Open report with only 1 record

[yu]

Hi...I have a form consist of employee information..How do I open a report that display only 1 employee information by click a "open report" button.

thanks in advance

 

[DougP]

Try this
Create a query that has the fields you want on your report.
then in the key field in the criteria box in teh new query, put this:
Forms![YourFormName]![YourKeyfield]

Save you new query
Open the form and pick a record
Then open the query it should show just that one record.
Then open your report in design view and change its "Record Source" to the new query.
Open your form pick a record then open the report it should also show the same record.

;-)

DougP, MCP
dposton@universal1.com

Ask me how Bar-codes can help you be more productive.

 

[TheInsider]

Or when you open the report with DoCmd.OpenReport, include a WHERE condition.

DoCmd.OpenReport "rptClients", acViewPreview,, "fldClientID = " & txtClientID

Rob Marriott
rob@career-connections.net

 

[Guest_imported]

Hi DougP,

Thanks for your help, It does work with your solution...