how can I use the results of a combo box in a label in a report

  • Thread starter Thread starter Cathy F.
  • Start date Start date
C

Cathy F.

I'm trying to use a combo box which pulls a date from a table as part of a
header in a Report. I'm not sure what the syntax to use should be.

This is the label I tried that failed.
Losses by Dealer by Tier for 12 months ending [Forms]![Dates].[Combo53]

Any suggestions???
 
Cathy-

Maybe I'm splitting hairs on this one, but you should be putting that into a
text box, not a label. And the exact source for your text box should be =
"Losses by Dealer by Tier for 12 months ending: " & [Forms]![Dates].[Combo53]
(with the = at the front)

Hope that helps.

Adam Milligan
 
Adam,

Thanks so much for your help.

Adam Milligan said:
Cathy-

Maybe I'm splitting hairs on this one, but you should be putting that into a
text box, not a label. And the exact source for your text box should be =
"Losses by Dealer by Tier for 12 months ending: " & [Forms]![Dates].[Combo53]
(with the = at the front)

Hope that helps.

Adam Milligan

Cathy F. said:
I'm trying to use a combo box which pulls a date from a table as part of a
header in a Report. I'm not sure what the syntax to use should be.

This is the label I tried that failed.
Losses by Dealer by Tier for 12 months ending [Forms]![Dates].[Combo53]

Any suggestions???
Click to expand...
Click to expand...
 
Back
Top