Combo Box displays as text box on form

[dwaterman]

I have used combo boxes on forms that display as text boxes. The data source is a query, which displays as a combo box. Other combo boxes on the same form work perfectly. I'm not sure where to look to resolve this one.

[ranman256]

Never heard of such a thing!
delete the combo, then copy a working one , then set the query to the deleted one.

[dwaterman]

I had two combo boxes doing this. The first one I was able to resolve by tinkering with the underlying query. I had two fields with the same name in different tables. One was not necessary to my form. When I deleted it along with my field, then selected my combo box again I was able to get it in the proper format.

I found no similar issue with the second combo box. I tried your suggestion and copied a working combo box. After changing the underlying query to direct to the correct data, I was able to get the combo box on my form. I'm still not sure what the issue was, but it now works.

Thank you!