G
Guest
I have a combo box to look up a value from a table
Table is called Symbols and has 2 columns:
Symbol_ID (autonum)
Symbol (text)
Sample data:
Symbol_ID Symbol
56 SM_SWITCH_14PIN
57 SM_SWITCH_16PIN
59 CONNECTOR_24PIN
61 SM_SWITCH_4PIN
SELECT Symbols.Symbol_ID, Symbols.Symbol FROM Symbols
ORDER BY [Symbol];
I have set the column widths for the combo to 1";1"
I can see the Symbol ID but nothing is showing for the text in the Symbol
field
I tried creating a query from the table and using that as the source instead
of the table and the same thing happens.
SELECT Query2.Symbol_ID, Query2.Symbol FROM Query2 ORDER BY [Symbol];
When I view the query, I can see data in both fields.
I have had this drop down in my form for years and now suddenly it shows
nothing. Even the field (a lookup) in the table itself is blank.
any ideas?
thanks
sandy
Table is called Symbols and has 2 columns:
Symbol_ID (autonum)
Symbol (text)
Sample data:
Symbol_ID Symbol
56 SM_SWITCH_14PIN
57 SM_SWITCH_16PIN
59 CONNECTOR_24PIN
61 SM_SWITCH_4PIN
SELECT Symbols.Symbol_ID, Symbols.Symbol FROM Symbols
ORDER BY [Symbol];
I have set the column widths for the combo to 1";1"
I can see the Symbol ID but nothing is showing for the text in the Symbol
field
I tried creating a query from the table and using that as the source instead
of the table and the same thing happens.
SELECT Query2.Symbol_ID, Query2.Symbol FROM Query2 ORDER BY [Symbol];
When I view the query, I can see data in both fields.
I have had this drop down in my form for years and now suddenly it shows
nothing. Even the field (a lookup) in the table itself is blank.
any ideas?
thanks
sandy