VBA To Access Multi-Value Lookup Field

[Rich Locus]

Hello:
Using the new feature in Access 2007, I created a table field using the
Lookup Wizard to allow multiple values for the State. For example, a user
can select one or more States (CA, NY, AZ) from a drop down in the form.

I get an error when trying to reference it using VBA as a type string:

For example,
Public Function ReadBusinessInfo()
....
Dim strBusinessInTheseStates As String
....
strBusinessInTheseStates = recIn!States

Is a multi-value field not a string? If I assign it as a Variant, then
there is no error, but I'm not sure how to reference the data.

Ideas?

 

[Allen Browne]

Take a look at the ELookup() function on this page:
http://allenbrowne.com/ser-42.html

You will see how it tests whether the fields is multi-valued, and if so
treats the contents as a recordset.

 

[Rich Locus]

Allen:
Your example will "get me going" again.
Thanks