View Single Post
 
Old April 22nd, 2009, 10:30 AM
SerranoG SerranoG is offline
Friend of Wrox
Points: 4,007, Level: 26
Points: 4,007, Level: 26 Points: 4,007, Level: 26 Points: 4,007, Level: 26
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Lansing, Michigan, USA.
Posts: 1,151
Thanks: 2
Thanked 14 Times in 14 Posts
Send a message via ICQ to SerranoG Send a message via AIM to SerranoG
Default

Actually, I would not do it this way only because it seems like a lot of hoops to do something quite simple.

I would set up the query with the proper fields that I want to come out of it, including UpdatedBy, without any criteria. The make the query the record source for the report. If you open the report by itself, it would give you all the records. However, if you open the report via the form, the code would look like this.

DoCmd.OpenReport stDocName, acPreview, , "[UpdatedBy] = '" & Me.cboStaff & "'"
__________________
Greg Serrano
Michigan Dept. of Environmental Quality
Air Quality Division