Report control values change based on drop-down selected from form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have text boxes labeling the title and subtitle of a report that I want to
change after a person selects a value from a drop-down list in a combo box on
a form. Please help with sample code references and/or tips on how to change
the values then open the report!
 
You will need to force the report to reformat in order for it to re-read the
value.

The simplest way to do that would be to close the report, and open it again.
 
You could do this in the Open event of the report. Your post doesn't give
enough information to post sample code that would be exactly what you need,
but for example purposes, I will assume you want to make the Title of the
report the selected value in your Combo:

Me.txtTitle = forms!frmMyFormName!cboMyComboBox
 
Thank you...it's working now!
--
Thanks!
Mona-ABE


Allen Browne said:
You will need to force the report to reformat in order for it to re-read the
value.

The simplest way to do that would be to close the report, and open it again.
Click to expand...
 
Mona-ABE said:
I have text boxes labeling the title and subtitle of a report that I want to
change after a person selects a value from a drop-down list in a combo box on
a form. Please help with sample code references and/or tips on how to change
the values then open the report!
Click to expand...
 
Back
Top