preview only Current form info on the rpt

[hengsin]

Let say there is one form about the employee. There are so many records on that form. For example,
EmployeeID EmployeeName
1 john
2 samad
3 lin
4 michael
5 lim
6 chew

Usually in the database, the report we are able to preview is all the information. In this example, the report generated will be list down all employee information.

Now i want to do is when i open up the Employee form and looking at Michael information on the form. I want to preview Michael only information on the report with a click of a button. No other information will on the report but only Michael. Can i know how to do this?

 

[Steve101]

In the code behind your button, add a Wherecondition argument to the Docmd.openreport command; for example:

docmd.OpenReport "rptYourReport", acViewNormal,,"EmployeeId=" me!EmployeeId

Hope this helps,



Steve Lewy
Solutions Developer
steve@lewycomputing.com.au
(dont cut corners or you'll go round in circles)