combo box displays numeric ID, not text

  • Thread starter Thread starter Techknownothing
  • Start date Start date
T

Techknownothing

I have a combo box that is populated by the fields from a table (States
in the Northeast).
The form displays the ID instead of the corresponding text (the actual
name of the State).
How do I make the form display the corresponding text instead of the ID?
 
I changed the width of the first field in the source table to zero and
the form still gives me the ID.

Techknownothing
 
Please list the fields in the sequence they appear in the query

Please indicated from the Format tab what the column count is:

Please list the field lengths as they are shown in the format Tab under
column Widths:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Lookup Fields and Combo Box 9
Linking two Subforms & showing name in place of ID? 1
How can I get a combo box to get data based on a text box? 19
Form Combo Box 2
Combo Box Lookup Value 4
Combo Box Display 3
Concatenate from a Combo Box 5
populate form fields based on combo box selection 1

Back
Top