Compile Error Message

[Finedean]

Hi All,
I took over an existing database. From time to time a message shows up, I close it and I am back to using the database. It's annoying.
If anyone knows the answer please help.

This the error message that shows up:
Compile error:
Invalid or unqualified reference

And the code that comes up with the word Requery Highlighted:

Private Sub Form_Timer()
'update the data so multiple users get latest data
Dim CurrRecord As Variant
CurrRecord = Me.CurrentRecord
'MsgBox (CurrRecord)
from .Requery
DoCmd.GoToRecord acDataForm, "frmMAIN FORM", acGoTo, CurrRecord
'End If
End Sub


Thanks in advance
Dean

 

[Remou]

You need an object to requery, probably Me. (or Form!ThisFormName) in this case.

 

[Finedean]

thank you.