combo box multiple values update query

[tubar]

I have a query that filters the data i need. it contains a combo box with multiple values. Is there a way i could do an update query to check one value (the same value) true in every record?

 

[pbaldy]

Sure, execute an update query that uses the combo value:

CurrentDb.Execute "UPDATE TableName SET " & Me.ComboName & " = True", dbFailOnError

 

[tubar]

still having issues. let me explain this way

My table is tblmain. There is a multivalued field called colors. The values checked are red blue green. I want a query that loads records that have red checked and add orange to be checked. All colors come from tblcolors and have primary ids.

Color Primary id
Red 1
blue 2
green 3
orange 4

i took pbaldy advice but im still new at this. i wrote this SQL in a query

insert into TBLmain (colors.[value])
FROM TBLmain
values (4)
WHERE (((TBLmain.LOCATION.Value)=1));

any help or direction would be appreciated

 

[pbaldy]

Sorry, I have no experience with multivalue fields. Don't like them, won't use them. If you use a multiselect listbox:

http://www.baldyweb.com/MultiselectAppend.htm