Text instead of Values

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

How do I get the info that is in my combo box lists to store in the table
instead of the corresponding values? i have read many threads going the
other way where folks want the values in the table. I also tried building a
query after reading it would show the information the way I want it, but it
comesback as values also. Any assistance would be greatly appreciated.
 
This might not be your solution based on what kind of field you are bound to.
Either change the record source to only the text field or set the text field
as bound column.

Lots of times the bound field is numerical to store the ID. Then in a query
join on the ID and display the text.
 
Sounds like you're using a Lookup Field in your table. What you're seeing is
only one of the many reason why many of us abhor them (see
http://www.mvps.org/access/lookupfields.htm for more reasons)

The only way to get the text would be to join your table to the lookup
table, the same as you'd have to do if you didn't use that aberation!
 
I think that got it. i had it bound to column1 and when i switched it to 2
where the correct information resided, it changed it on the table. Thank You
Very Much!
 
Back
Top