reports of a particular employee

[rameshjctr]

friends,
I have created a report based on query. when i open the report it will print all the employees in the table. i want to get the report for a particular employee.
how to write the code for that. i tried to with a global variable declared at login form and get stored the login id in the global variable. then on the load event of report i tried to print the report using the global variable. but nothing happens it lists all the employees in the table. how can i correct the error?

thanking you in advance



ramesh j

[ranman256]

No code needed,
in the form, put the combo box to select the employee you want then open the report base on it
docmd.openreport "myRpt",,,"[id]=" & cboEmp

[rameshjctr]

thanks ranman.

ramesh