Problems saving records in Access 2000

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When opening reports from forms, recent changes to data aren't reflected.
I've tried DoCmd....acSaveRecord. In some situations it works, an error
message is generated. Is there a general pattern as to when this will work
and when it won't? Is there a better way to do it?
Thanks,
Barb
 
In the Click event of a command button, you should be able to use:
If Me.Dirty Then Me.Dirty = False
or if you prefer:
RunCommand acCmdSaveRecord
before your OpenReport line.

If you do get an error message, it might be important to read it and find
out why the record is not being saved.

If you are closing the form, there is a serious data-loss bug with the Close
action where Access silently discards your entry:
http://allenbrowne.com/bug-01.html
 
Back
Top