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