Forum Discussion
Please help!!! Run-time error 3828 Cannot reference a table with a multi-valued field ...
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.
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...
- George_HepworthFeb 18, 2021Silver Contributor
As I suggested in the last post, I wonder if we're chasing the wrong rabbit.
I was under the impression you'd removed the MVF fields from tables. Is that not correct? Is it possible that the COMBO box that provides the criteria for the query is actually where the MVF field might be hiding?
- bbalzerFeb 18, 2021Copper Contributor