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

 

[Pat Hartman]

I also do not use multi-value fields for lots of reasons. One of which is you need to write custom SQL and the data type is not comparable with SQL Server which I use for most of my BE's.

So, to solve your problem, either ditch the multi-value field and go with a standard 1-m relationship displaying the many-side data in a subform OR use Google to find the custom SQL you need to manipulate multi-value fields.