Form1 has a Refresh Command Button.
It's been working fine but doesn't now - I get a MsgBox
"The command or action 'Refresh' isn't available now."
- any ideas?
I tried deleting the Command Button and making a new one - didn't work. the new VBA (written by the Wizard (so I don't properly understand it)) is;
Private Sub RefreshCmd1_Click()
On Error GoTo Err_RefreshCmd1_Click
DoCmd.DoMenuItem acFormBar, acRecordsMenu, 5, , acMenuVer70
Exit_RefreshCmd1_Click:
Exit Sub
Err_RefreshCmd1_Click:
MsgBox Err.Description
Resume Exit_RefreshCmd1_Click
End Sub
It's been working fine but doesn't now - I get a MsgBox
"The command or action 'Refresh' isn't available now."
- any ideas?
I tried deleting the Command Button and making a new one - didn't work. the new VBA (written by the Wizard (so I don't properly understand it)) is;
Private Sub RefreshCmd1_Click()
On Error GoTo Err_RefreshCmd1_Click
DoCmd.DoMenuItem acFormBar, acRecordsMenu, 5, , acMenuVer70
Exit_RefreshCmd1_Click:
Exit Sub
Err_RefreshCmd1_Click:
MsgBox Err.Description
Resume Exit_RefreshCmd1_Click
End Sub
Last edited: