Displaying specific reports

[Ptrif]

I have a form that shows individual emplyoee information, i want to add a button to the form that will open a report with the current employee in the report automatically, is there a way to accomplish this?

Paul

 

[Norris68]

Use the Criteria parameter of the DoCmd.OpenReport call. This is the same as a SQL WHERE clause without the WHERE keyword. e.g.

DoCmd.OpenReport "rptEmployee", acViewPreview, ,"EmployeeID=" & Me.txtEmployeeID

Assumes your employee PK is called EmployeeID and is bound to a textbox on your form called txtEmployeeID.

Design your report so that it will return all employees. The criteria parameter then filters the results and only reports the ones that match.