update a combo box using an update query

[kr]

I have 2 columns. Column A (which is a combo box) and column b (a yes/no
field). I have a couple hundred records that where column b is yes then
update column a to a certain value in the list. I thought the update query
could do this. Am i missing something with the data type for the combo box?

 

[John Spencer]

It sounds as if you are using a table with a field that is a lookup
field. If that is the case, what you see on the screen is probably NOT
what is actually stored in the field in the table.

This is probably the major reason that many (if not most) MVP feel that
this feature is a misfeature.

You need to take a look at the source for the lookup field (in design
view) and determine where it is getting its value from and then which
displayed value is equal to the value you want to update to.

Personally, I don't use lookup fields. And my users don't see queries or
tables directly so they don't have to worry about having a lookup field
with a combobox. If the form needs a combobox, I add one.

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================

 

[kr]

thats exactly what i did. i created a lookup field - combo box - in which I
typed the values myself. and for right now i have 5 days worth of data in
that. what's my best options. I attempted to update to the actuals words in
the value list and then i attempted using a number but it doesn't seem to
work as well. I saw somewhere about current selection for combo boxes but
eh....didnt quite get it.

 

[kr]

i'm not good with writing the SQL statements - i was using the design view -
but when I switched over to the sql view just to see what it looks like it
looks like
SELECT TABLE A
SET combobox to "other"
WHERE column A in Table A = Yes
Something to that effect. I'm not looking at it right now. obviously there
is somehting i'm not getting with the values of the combo box