Combo Box Value in report = 9 and not september

[baz7621]

Hiya all

I have a form and on it i have a combo box from which the user has to choose a month.

The row source for the combo box is



code:--------------------------------------------------------------------------------
1;"January";2;"February";3;"March";4;"April";5;"May";6;"June";7;"July";8;"August";9;"September";10;"October";11;"November";12;"December"
--------------------------------------------------------------------------------


With the row source type as value list

When the month is choosen and the ok button is clicked a report is produced for that months takings.

What i want to do is in the title i want to display the month of the report. So if the user clicks January in the form the report should title should contain January.

So I created a label saying "Report for Month of" then I created a txt box with named txt_month

With this i went into properties and put the control source as

= Forms![Best Sellers]![cbo_month]

But now for the problem it comes back as a number so if the user picks September on the form the report display the number 9 instead of September

Can any one help

Fanx

 

[baz7621]

fanx alot mate that works a treat