Posted By

heislekw on 05/01/11


Tagged


Versions (?)

Printing without saving current edits


 / Published in: Visual Basic
 

Changes to the current record are not saved just because you click a button to perform some other action. Novice Access users often forget to force a record save before executing an action such as OpenReport [or Close, etc.]

  1. ' Include this line before executing an action such as OpenReport:
  2.  
  3. If Me.Dirty Then
  4. Me.Dirty = False
  5. End If

Report this snippet  

Comments

RSS Icon Subscribe to comments
Posted By: heislekw on May 1, 2011

Alternative?:

If Me.Dirty Then RunCommand acCmdSaveRecord End If DoCmd.Close

You need to login to post a comment.