:) Hi all, (using VB 6)

How can include a variable from a FORM into a DataReport print page.
Also ,

How include the varible to the cratria insdie the SQL of the DataRepot.

Thanks.

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