Reset a form after report close

  • Thread starter Thread starter enayat
  • Start date Start date
E

enayat

is there a way to put code in the "close" property of
report to make a form move to a new record??
 
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
 
Back
Top