Software

Ask something
Question Locked

MS Access - Public Variables Visa Reports

0 helpful
3 replies

by njoroge

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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

3 replies

by john.a.wills

The criterion in OpenReport is called criteria because someone designing VBA didn't know his singual from his plural. Add to your OpenReport parameters
criteria="=" & or something similar.

by john.a.wills

The criterion in OpenReport is called criteria because someone designing VBA didn't know his singular from his plural. Add to your OpenReport parameters
criteria="=" & or something similar.

This discussion is closed to new replies.