Could be many things. Examples:
- Does this happen when the record is being saved?
Anything in Form_AfterUpdate or Form_AfterInsert that could be dirtying the
record, or in the events of the controls that could cause interactions, or
the Unload or Close event of the first form, or the Open or Load event of
the next form?
- Using Conditional Formatting?
- Does the status bar show "Calculating?" during this time?
- Are the Name AutoCorrect boxes checked under Tools | Options | General? If
so, Access will be tracing renaming during the form load.
To start tracing the source of the problem, break it into two parts. Does it
happen when you unload the existing form, or when you open the next form?
Once you decide that, you can begin to dump things from that process, until
you pin down the culprit.
