form asking for recordsource

[maxmangion]

Hi,

In the attached database when i try to open the form frmMovies (which has four subforms) I am getting the following message box.

You misspelled the name, or it was deleted or renamed in the current database, or it exists in a different database.

In the Form or Report's design view, display the property sheet by clicking the properties button, and then set the recordsource property on to an existing table or query.


After clicking ok, This message box repeats itself for the other three recordsources and then the form loads but without the actual info. Then i close and re-open the form, and it shows up fine.

Any ideas what might be going on pls ?

P.s. if the first time you open the database the form will open up fine, please close the database and try again, as normally its there when it happens.

Also, i have already tried exporting the objects to a new database, unticked the Autocorrect Name option and decompile the database, however, all to no success.

I even tried running the database on another pc and the same thing happened.

Any feedback is greatly appreciated

Thank you

 

[ansentry]

I opened and closed it several times and each time moving through the records.Sorry to tell you, it worked fine.

 

[maxmangion]

thanks for your reply. It's really weird, as it happened to me on two different computer (both computer and work pcs), and it only happens the first time i try to open the form, as then i close it and re-open it and it works fine.

I really can not understand what might be going on and if anyone can shed some light on what else i can try i do really appreciate it.

Thank you

 

[maxmangion]

anyone can give me some feedback on what else i can check please ?

Thank you