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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combo Box on Report 10
clear a filter on close 4
Closing A Report 2
Any way to refresh a report? 4
Filtering Report Data 3
Print a report without displaying print preview 1
Dialog Form for filtering report 5
Form, instead of Report, Prints ??? 0

Back
Top