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

Fred Hooper fahooper at trapo.com
Sat Jul 3 12:39:57 CDT 2010


 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



More information about the AccessD mailing list