How can I force refresh form in a MS Access 2003 with VB, I created a refresh btn with a wizard and it does not work

How can I force refresh form and 2 subforms in a MS Access 2003 with VB, I created a refresh btn with a wizard and it does not work. Access says "an action or cmd refresh is not available now"  I place the btn on a form
Here is the btn code that was generated by access;
Then set the Timer Interval to 10000
(right below On Timer in the Event tab.
Private Sub Command15_Click()
On Error GoTo Err_Command15_Click
DoCmd.DoMenuItem acFormBar, acRecordsMenu, 5, , acMenuVer70

Exit_Command15_Click:
    Exit Sub

Err_Command15_Click:
    MsgBox err.Description
    Resume Exit_Command15_Click
   
End Sub

I also tried to use on timer event in form properties
I tried the Me.requery and Froms!fmetersstatus.requery
I set interval to 1000

In both cases Access would give me errors: "macro me could not be found" and that macro "Froms!ffmetersstatus could not be found". Do I need to creat macros

Please help
Thank you


    Start Free Trial