I am an access beginner so please excuse simple question.
I can refresh my form data by having a button on the form generated by a wizard. This works fine and has the code:
Private Sub Command12_Click()
On Error GoTo Err_Command12_Click
DoCmd.DoMenuItem acFormBar, acRecordsMenu, 5, , acMenuVer70
Exit_Command12_Click:
Exit Sub
Err_Command12_Click:
MsgBox Err.description
Resume Exit_Command12_Click
End Sub
I want to get the same effect by using code on the enter property of a field so the form is automatically refreshed when the user selects the field.
please could I have the code to do this?
me.refresh
in the OnEnter event of the field
Walt