Shift + F9 translated to a command button

[Peter]

Hi again all at this fantastic place....how do i translate the Shift + F9
(requery) a form...???

 

[fredg]

Hi again all at this fantastic place....how do i translate the Shift + F9
(requery) a form...???

In code from an event on that form?
Me.Requery

 

[Peter]

Thanks fredg...made my day! i used this from the refresh button code..
Private Sub Requery_Form_Click()
On Error GoTo Err_Requery_Form_Click


Me.Form.Requery

Exit_Requery_Form_Click:
Exit Sub

Err_Requery_Form_Click:
MsgBox Err.Description
Resume Exit_Requery_Form_Click

End Sub

Once again, thanks a lot!