Hi All,
I have defined a public variable in a database which is working very well in all forms. Now i want to use the same to filter records for a particular user. My public variable is captured from login form which is wuser. The code am using is
DoCmd.openreport “Active Jobs By Engineer”, acViewPreview, “”, “[Jobmaster]![Projectcoordinator]='” & Wuser & ” ‘”, acNormal
Am calling this report from the switchboard.
Any assistance will be highly appreciated.
Joseph