When I create a new database from an Access database stored in SourceSafe and compile it I get an error message. if I cut the text in the Record Source field of the form with the error, click off the Record Source field and paste back the old table name or SQL then recompile the error goes away.

What is causing this and how to avoid it.