[AccessD] Snapshot question continued

You can't.  You must use the report's recordsource to filter the records
to print. The recordsource needs to be a query and the records in the
query that you want to select from must come from those selected on the
form.  So your SQL statement in the query might look something like
this:

SELECT * FROM tblOrders _
	WHERE OrderDate >= Forms!frmMyForm!FromDate _
	and OrderDate <= Forms!frmMyForm!ThruDate


John V. Ruff - The Eternal Optimist :-)
Always Looking For Contract Opportunities

Home: 253.588.2139
Cell: 253.307.2947
9306 Farwest Dr SW
Lakewood, WA 98498

"Commit to the Lord whatever you do,
                and your plans will succeed." Proverbs 16:3



-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller
Sent: Monday, May 26, 2003 7:58 AM
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] Snapshot question continued


How do you pass a WhereCondition into your nicely concise code?

Arthur

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Ruff
Sent: May 26, 2003 9:55 AM
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] Snapshot question continued


This should work for you

    DoCmd.OutputTo _
            ObjectType:=acOutputReport, _
            ObjectName:="rptMyReport", _
            OutputFormat:=acFormatSNP, _
            OutputFile:="c:\myreport.snp"


_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com