Pass Form Variable to Report (DataReport)

coboy · #1 (**permalink**) September 20th, 2004, 04:41 AM

:) 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.

SerranoG · #2 (**permalink**) September 22nd, 2004, 12:19 PM

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
To pass value of string variable to another form	thillai	Visual Basic 2005 Basics	5	March 13th, 2008 03:29 AM
pass session variable to report select where	nutrino	ASP.NET 2.0 Basics	0	October 25th, 2006 09:16 AM
Pass variable to main form dataset	spacky001	ASP.NET 1.0 and 1.1 Basics	2	September 13th, 2006 10:10 PM
How to pass data directly into datareport .	baburam	VB How-To	1	May 23rd, 2006 03:43 AM
pass form elements variable	vickyj	Classic ASP Basics	0	October 29th, 2005 04:58 AM