Combobox not selecting

[LB79]

Hello,

Im having problems with a combobox. Ive set it up to read a specific column of a table and it does, but when I select and item from it, nothing happens - it doesnt select or close the combobox or anything. Im not sure whats wrong with it. Does anyone know what Im doing wrong?

Thanks

 

[RuralGuy]

Is there any chance the ControlSource of the ComboBox is a non-updateable field?

 

[LB79]

Thansk for your response...

I can see the control source... theres nothing written in it. If I link it to the table i get Name? in the combobox...

Thanks

 

[RuralGuy]

It looks like the ComboBox is unbound. How about posting the following properties:
1)RowSourceType
2)RowSource
3)BoundColumn
4)Enabled
5)Locked

 

[LB79]

I made a combobox in the same way on Friday that was unbound and that works fine.
I just tried binding the combobox and it gave me the same problem...

Row source type = Table/Query
Row source = SELECT Date_Range.Month FROM Date_Range ORDER BY [Month];
Bound column = 1 (theres only 1 column in the table).
Enabled = Yes
Locked = No

Thanks for your advice.

 

[RuralGuy]

I don't see anything that might be causing the problem. Try using the wizard and create another ComboBox to do the same task and see if you still have the same problem.

 

[missinglinq]

The behavior noted is the behavior of a cbo that has Locked set to Yes. Since this isn't the case here, I'd go with Allan's suggestion and simply recreate it.

 

[LB79]

Hello - Thanks for your suggestions. I finally found out what was going on.
In the properties of the form itself I changed ALLOW FILTERS to YES and it works.

 

[GirishBreakTheRules]

Actually i fink your query might just have some problem:

Try SELECT Date_Range.[Month] FROM Date_Range ORDER BY Month

The format works fine: SELECT [Column_NAme] FROM Table Order by Column_Name;

Checked the locked property and rowsource property aswell.

Regards