OpenArgs

[Mermogoat]

Can someone give me an example of the use of OpenArgs when opening a report? I have tried it according to the Help file, but it does not work. Thanks

 

[AncientOne]

OpenArgs only works with the OpenForm method of the DoCmd object. (refer to Help). It can't be used with a report.

 

[Mermogoat]

Then is there a way to pass text on to a Report that you are opening?

 

[Pat Hartman]

You can create a hidden field on a form and put the value you want to pass there. The report will then be able to obtain the value by referencing the form field.

 

[Mermogoat]

How would I reference the form field?

Textbox.value = [form text field] <--what goes in there?

 

[Mile-O]

Forms!frmYourForm!txtYourTextBox

 

[Mermogoat]

Thanks for all the help. God bless