MS Access - Public Variables Visa Reports - TechRepublic
Question
May 16, 2008 at 12:01 AM
njoroge

MS Access – Public Variables Visa Reports

by njoroge . Updated 18 years, 2 months ago

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

This discussion is locked

All Comments