View Single Post
 
Old September 22nd, 2004, 12:19 PM
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

Use the DoCmd.OpenReport method. For example, to filter on a text variable,

DoCmd.OpenReport "Your Report Name", acPreviewPrint, , "[Your Table or Query Field] = '" & Me.txtYourTextboxField & "'"


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division