[AccessD] Report Puzzler - Trying to plug a value into a TextBox when using DoCmd.OutputTo

Fred,

Thanks for the help.  I really appreciate it.

The TextBox on the report now has the value in it and I am all smiles.

Thanks again,
Brad


-----Original Message-----
From: accessd-bounces at databaseadvisors.com on behalf of Fred Hooper
Sent: Sat 7/3/2010 12:39 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Report Puzzler - Trying to plug a value into a TextBox when using DoCmd.OutputTo
 
 You could fill the text box with the value from a (maybe hidden) field
on a form using syntax like: "=Forms!frmReplace!txtStartDate". So, just
before your DoCmd, place the value in the field.

Fred

On 7/3/2010 1:27 PM, Brad Marks wrote:
> I have a Text Box that is being filled in with a value in the "On Load"
> event of a Report.  This works nicely when I view the report via Access.
>
>
>
> Now I would like to use the "DoCmd.OutputTo acOutputReport" command to push
> this report to a file.
>
>
>
> Is there a way to plug a value into this TextBox when using the
> "DoCmd.OutputTo acOutputReport" command?
>
>
>
> It appears that the "DoCmd.OutputTo acOutputReport" command is not doing a
> "Load" of the report.
>
>
>
> I am missing some here.  Probably something really simple.
>
>
>
> I have experimented with other Report Events that might be available with
> the "DoCmd.OutputTo acOutputReport" command but have not had any luck.
>
>
>
> Thanks in advance for your assistance.
>
>
>
> Brad
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.