I'm not sure why but every notification email from your posts includes a long section of raw text indicating you have attempted to paste an image into your answer. That doesn't work for this forum
So I don't know whether I've seen all the screenshots you meant to include
As already stated I've tested my app more than one in Access 2007 and don't get the 31602 error with the correct reference added. As I'm unable to replicate it, I can't fix it
I can fix the error 2164 that occurs in A2007 only. But there's no point unless the other issue is solvable
Can I check. Do you get error 31602 with my example database or just when you import items into your own database?
Are you able to upload a cut down version of your database with just the items need to text this and all confidential data either removed or altered.
If so, please do that, compact & zip then upload to here - click the Go Advanced button and follow the instructions.
Or you can zip & email it to me using the link in my signature line