1) I assume the declaration is in a bas module (not Form module), yes?

2) Is the same rst object used to hold different recordsets across multiple forms?

3) Could you post the Form_Load and Form_Activate code?

4) If you write an error handler in the form_load that looks something like this, what is written to your c:\\myerrors.log file?

Form_Load()

On error goto Load_Err

...

Load_Exit:
Exit Sub

Load_Err:
' I don't remember if DAO has an errors collection or not, but I think it does.
' If it doesn't, strike out the errX stuff below
Dim hFile as long
Dim errX as Error

hFile = Freefile()
Open "C:\\MyErrors.log" for Append as #hFile
Print #hFile, Err.Description
For Each errX in DAO.Errors
Print #hFile, errX.Description
Next errX
close #hFile
Resume Load_Exit