Reset a form after report close

E

enayat

is there a way to put code in the "close" property of
report to make a form move to a new record??
 
A

Allen Browne

This code assumes the form is open, saves any edits, and makes sure it has
focus so it can move to the new record:

Private Sub Report_Close()
With Forms("YourFormNameHere")
If .Dirty Then 'Save before move.
.Dirty = False
End If
.SetFocus
RunCommand acCmdRecordsGotoNew
End With
End Sub
 
Top