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
 
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

Cannot Save Record(!!) 3
TransferSpreadsheet with Formula Issue 6
Code to force SQL to save a record 2
nodata on reports 2
DoCmd Access 2007 4
adp form save\update problems 3
Open Report to specific record 4
Record insert/delete anomaly 0

Back
Top