Forum Discussion
Please help!!! Run-time error 3828 Cannot reference a table with a multi-valued field ...
In general, multi valued field are to be avoided, just a headache! Build your own related table to get the same result.
- George_HepworthFeb 17, 2021Silver Contributor
It was my understanding, earlier in this thread, that the MVF and Lookup fields were removed from the table on which the query is based.
When the query is run with a hard-coded criteria in place of the form control reference, it created the .csv file properly as long as there was no : in the file name.
However, when the query was restored to the original form control reference criteria, it failed with the same error message. That leads me to believe there is something else going on.
- George_HepworthFeb 17, 2021Silver Contributor
Hm. It just now occurred to me that this control on the form may be bound to a field in a DIFFERENT table and that table may be the one with the MVF field here. Is that possible?
- bbalzerFeb 18, 2021Copper Contributor
I modified the query with the where clause and added the code to the button, but still get the 3828 error. Not sure why this seems so difficult? thanks for your help...any other ideas?
Project No is an unbound field...