VBA code to refresh form data with out clicking button
Posted on 2004-04-02
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
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?