Report labeling from combo box

[McFestoe]

I haeve a combo box on a form that the use selects the month they wish to run a report for, the report runs but i cant get it to display on the report the month it is run for. and i just cant get it to put the month form one of the field due to their are four months and the report could be run for september but september could be in month1, month2, month3, or month4.

Is there a way to take the the vaule of the combo box and print it on the report?

Thanks

 

[RickSpr]

It can definitely be done, but the best way depends on whether the form is still open when the report runs.

If the form is still open, you should just be able to set the report control's Control Source to "=Forms![<form name>]![<control name>]"

Otherwise, let the form's Close event (or may an OK command button's Click event) store the value of the text box in a Public variable in a standard module. Then set the report control's Control Source property to an expression that calls a VBA function that simply returns the value from the public variable.

Rick Sprague
Want the best answers? See faq181-2886
To write a program from scratch, first create the universe. - Paraphrased from Albert Einstein