Prev: Use combo to print report between two sets of dates
Next: Entering Report Parameters through a Form
From: WebJunkey via AccessMonster.com on 27 May 2010 17:39
Hey again guys,

I have a simple form that lets a user type in an account number/year and get
a report when you click a button. The button just has some simple code that
does docmd.openreport and pushes the account number/year into the where
argument of openreport. Now i'm trying todo it in mass and just have
outputto send the pdf directly to a pdf file. The issue i'm having is that
OutputTo doesn't allow you to pass a 'where' clause to the function, like
openreport does. What's my alternatives to getting around this, pushing a
new recordsource sql command to the report before it calls output to? only
thing i can really think of. Any advice appreciated.

Thanks in advance.

--
Message posted via http://www.accessmonster.com

 | 
Pages: 1
Prev: Use combo to print report between two sets of dates
Next: Entering Report Parameters through a Form