VBA To Access Multi-Value Lookup Field


Rich Locus

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.


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question