Combobox not displaying selected item (1 Viewer)

[jpl458]

On a form, I have created a combobox that gets it s values from a query. I can hit the drop down arrow and all the data is there as it should be. However,when I click an item in the list nothing happens, the value I selected does not move to the top in the textbox area of the combobox. I know this is something simple, but I can't see it. I've read up and think I am doing it correctly. The query is simple enough:

SELECT DISTINCT Mastertbl3.companyname1
FROM Mastertbl3;

Is there something in the property sheet that needs to set?

Thanks

 

[June7]

Maybe. Show properties of combobox.
RowSource (you did that)
BoundColumn
ControlSource
ColumnWidths
ColumnCount

Why are you repeating company name in this dataset? Why not saving a CompanyID as foreign key from a Companies table? Why does field name have a number suffix?

 

[jpl458]

Here is the data part of property sheet:

Thanks. Hope this helps. Let me know if you need more.

 

[June7]

Doesn't really answer all my questions. Cannot see any cause of issue from that.
Might want to provide db for analysis.

Why build an SQL statement instead of just referencing the saved query name? Why not pull directly from table instead of a query based on a query?

 

[pbaldy]

Make sure the form allows edits (isn't read only). If memory serves, that can prevent selections in a combo.

 

[jpl458]

Make sure the form allows edits (isn't read only). If memory serves, that can prevent selections in a combo.

I haven't looked but I think we have Bingo! here. As a matter of fact, the editing gets turned on and off under various conditions, but when it open, it's locked.

Dead solid perfect, you were right as rain.

Thanks

 

[pbaldy]

Happy to help!