The command or action 'Refresh' isn't available now,

[Steve C]

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

 

[JHB]

Try this code, maybe it helps:

[SIZE=2]Private Sub RefreshCmd1_Click()[/SIZE]
  Me.Refresh
[SIZE=2]End Sub
[/SIZE]

 

[Steve C]

Thank you JHB. sorry I didn't say thank you straightaway. I've not been on the internet due to a berevement.