CODEWITHSUNDEEP
ms-accessvbams-access-2007
MultiGuy
MultiGuy

Reputation: 1012

How can I update a multi value combo box in ms access vba?

I need to know how to update the value of a multi-value combo box in MS Access? I have a continuous form where each record contains a multi-select combo box. What I'm needing to do is do an UPDATE of all Similar records on the form in the AfterUpdate() proc of that combo box.

I'm currently doing this with UPDATE sql on a form that has a regular combo box. However, I get an error stating "An UPDATE or DELETE query cannot contain a multi-valued field." So I need another option.

I can simply run a loop through the records in the recordset, but I was hoping for a more eloquent solution. :-)

Thoughts?

Upvotes: 0

Views: 1030

Answers (1)

MultiGuy
MultiGuy

Reputation: 1012

Wow, I found the answer....

DON'T USE MULTI-VALUE COMBO BOXES!!!

...now to redesign....

Upvotes: 1

Related Questions