Problem!!!

[Newguy28]

Hi guys,

I have set in a query that requires the user to type in a particular month that they require. I have created a table with all the months listed and and in the form, the user has a combo box from which they select the desired month. However, when it comes to opening the report, the box appears which asks the user to enter the desired month, but when for example they type " May" nothing appears, but when i look at my query again, the name of the month doesnt appear there only a number eg, 1=January 2=February and so on. So what have i done wrong???

Thanks in advance.

 

[Ron_dK]

Go to the combobox properties and set the "Bound column" to the field that displays the month. Seems to me that the bound column property is currently set to the month-ID. This gives you the ID number.
In setting the bound column to 2, it will display the month, provided column 2 is the month in the underlaying query.

 

[Newguy28]

Thank you very much, problem solved!!!!

 

[Ron_dK]

Glad I could help.