Getting Data into a Report's Header

[regava]

Access 2000 - I have a form which has four options to print a report based on the option selected. My problems is that I have not been able to carry the option selected to the Header of the Report. One of the things that I tried was to set up a Public variable and stored the option there, but when I get to the report the variable is not available.
Any ideas? Help is appreciated.

 

[dhookom]

Could you provide more details regarding your option group and your attempts?

You should be able to bind a text box to something like:

=Choose(Forms!frmName!OptGrpName,"Caption1","Caption2","Caption3","Caption4")

Duane
Hook'D on Access
MS Access MVP

 

[regava]

dhookom thank you for your reply. That is exactly what I did and solved my problem. However, I had to enclosed the form name in brackets (ie. [ ]![ ]![ ]). Have a wonderful day.

 

[dhookom]

If your object names didn't contain spaces or other non-standard characters, you wouldn't need to use the []s ;-)

Duane
Hook'D on Access
MS Access MVP