I want to have a user fill a field on a form that will be displayed on a report.
Eg: The Name of an event would show up on every ticket.
I would prefer not to fill every record in the table with the same data.
I want to have a user fill a field on a form that will be displayed on a report.
Eg: The Name of an event would show up on every ticket.
I would prefer not to fill every record in the table with the same data.
Create the form with the Text Box you want.
Then create a Report with an Unbound Text Box.
Now create a new Query in Query design. No need to select any tables.
Using the Wizard from the Criteria area search the form and find that control you want to display in the Report.
You should end up with something like > Forms![frmMain]![txtYourControl] <
Copy and paste this into your Reports Text Box, Control Source like this.
=Forms![frmMain]![txtYourControl]
Let me know how this goes.
Ha!!! That works great.
Thanks for pointing me in the write direction....