View Full Version : report command button


$lim
03-07-2005, 12:26 PM
I have a database that users log into to keep track of there work hours. At the bottom of the form i have a command button that will bring up a report of all the users hours. Is there anyway that i can have a command button that brings up the user's that is logged in hours. I was thinking that maybe i would have to make a combo box and have them select there name from there and then click on the command button to view the report.

Ukraine82
03-07-2005, 01:11 PM
Try setting up a User Name parameter.

If you're running a report from a query try doing something like this for your UserName Field criteria

Like [Reports]![ReportName]![UserNameField] & "*"

or

Like [Forms]![FormName]![UserNameField] & "*"

hth,
Michael