i have a created a database to keep track of my movies collection. The main form in this database is a form in which i enter various details about a particular movie. In this same form i have created a table control with 4 pages in which on each page there is a subform. These subforms holds information about that movie and their recordsources come from 4 different queries.

Page 1 has a recordsource qryMovieakaTitles in which it holds additional title names which the movie may be known as
Page 2 has a recordsource qryMovieActors in which it holds the main actors in that movie
Page 3 has a recordsource qryMovieGenres in which it holds the the name of the genres which the movie may fit into
Page 4 has a recordsource qryMovieKeywords in which it holds a set of keywords which are related to the movie


My main problem is that sometime when i come to open the main form frmMovies i am getting a message box stating:

the recordsource "qryMovieakaTitles" specified on this form or report does not exist.

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.

I tried importing the objects to a new database and compact and repair and all went fine, but sometimes this error still crops up, and i have to import the objects again to a new database.

Any ideas what might be causing this problem, and if there is any resolution to resolve this issue?

Thank you for any feedback.