Report Label Linked to an Open Form

[andrewneal]

How would I get a report label to print exactly what is in a form dropdown list on an open form? I have my sorting and everything else working perfectly (using hidden triggers), now I simply need the report label to simply show what dropdown list I chose on the form.

I cannot use a record source function because one of the choices in that table sometimes shows up as the 'office' and they cannot have that happen. They need the report to show exactly what is in the dropdown list; something like it would if it were linked.

Report Label Name = Office
Form Dropdown List Name = Activity

Would it be better to make the report label a text box instead and link it that way?

Thanks!

Drew

 

[Dennisk]

use a calculated text control
=Forms!myForm!myControl

 

[andrewneal]

Unfortunately this did not work ... When I open the report the text box is blank.

The control source for the text box is: =Forms!ReportChoice!Combo8

Am I missing something?

 

[Dennisk]

that is a standard technique to display data on a report from a form. is the visible property of the control set to no, as if there was an error ie the form was closed then the control should display #error.
or

if you select an item from the combo box and then open the report from the database window, then that may account for it. This would be because the control has not been updated as focus has not moved away.

 

[andrewneal]

That was it... It was hidden; not sure why since I thought I checked that! I blame the pain medication!

Thanks again!