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
|