Forum Discussion
Please help!!! Run-time error 3828 Cannot reference a table with a multi-valued field ...
I have a form that passes a string to a query. From the form, I want to convert the query results to a csv file. I have checked several posts on this subject and they don't seem to have any problem...
Problems like this are part of the reason most experienced Access developers strongly encourage NOT using multi-value fields in tables. They are like sugar cubes, really sweet at first, but sooner or later you realize eating cubed sugar is not a good plan if you value your health.
The problem is not the DoCmd statement. The problem is the method you have to use to extract the values from the items in the MVF.
It's possible, but it remains a second-tier approach.
You might find some useful information in this documentation.