.Requery

[Elamranii]

I am getting this error message on this code:

Compile error
invalid or unqualified reference

It does not like the word: .Requery
Can anyone help

Thanks in advance

Private Sub Form_Timer()
'update the data so multiple users get latest data

Dim CurrRecord As Variant
CurrRecord = Me.CurrentRecord

'MsgBox (CurrRecord)

.Requery
DoCmd.GoToRecord acDataForm, "frmMAIN FORM", acGoTo, CurrRecord

End Sub

 

[jebry]

Hi!

Use Me.Requery

hth


Jeff Bridgham
Purdue University
Graduate School
Data Analyst

 

[Elamranii]

problem solved. Thanks.
If you do not mind me asking, what does requery do?

 

[jebry]

Hi!

It reruns the record source of the form in case there has been any changes that the user may need to see.



Jeff Bridgham
Purdue University
Graduate School
Data Analyst

 

[Elamranii]

Thank you very much