Error 2450 Microsoft Access can't find the form referred to in a macro expression

[andykevans]

Hi Guys,

Pretty much a novice at Access so I apologise if this is obvious:

I have an Access form called MainForm1. On the form is an execute button which starts a vb script. The script runs along nicely importing lots of records using the docmd.transfertext command. It then, at random points in the records, will return the above 2450 error saying it can't find the MainForm1, even though it's open and the only form in the database with no sub-forms. I then have to close the access session and reopen to start again and next time it will work successfully.

Any ideas what's going on?

Regards,

A

[Tanis]

Post the code you are using,. Might be something in there.