Getting error 3464 "Data Mismatch in critical Expression"
Occurs on this line DoCmd.OpenForm "frmCDTracksFilter", acFormDS, "zqryCDFinder"
I can Open the Form by itself, but it contains the last instance of "zqryCDFinder", not the current one.
I can also open "zqryCDFinder" by itself; there's no errors and it has the correct data. It's the second time I've had this error, the first time I moved everything to another folder and it worked ok again. I was trying to isolate just the components being used to more easily see the problem. But it went away. Then as I entered more data and executed that line a few times the error returned.Have done "Compact & Repair" without any effect. Using Access 2007.
Occurs on this line DoCmd.OpenForm "frmCDTracksFilter", acFormDS, "zqryCDFinder"
I can Open the Form by itself, but it contains the last instance of "zqryCDFinder", not the current one.
I can also open "zqryCDFinder" by itself; there's no errors and it has the correct data. It's the second time I've had this error, the first time I moved everything to another folder and it worked ok again. I was trying to isolate just the components being used to more easily see the problem. But it went away. Then as I entered more data and executed that line a few times the error returned.Have done "Compact & Repair" without any effect. Using Access 2007.