Form

[Trilback]

I only want to update a table with the form data after its complete and I use the DoCmd.RunCommand acCmdSaveRecord as I have an If statment that checks a field for something and if thats that I don't want that record in the table to update as I also want the form to be cleared if that makes sense.

 

[JHB]

I think you should use Me.Undo instead!
Normally, data in forms are saved when you leave the current record, closing form, going next record etc., (without any extra action).

 

[Trilback]

I think you should use Me.Undo instead!
Normally, data in forms are saved when you leave the current record, closing form, going next record etc., (without any extra action).

I will try that when I get to work and see if that can work

 

[gemma-the-husky]

you probably do not want to save the record with a button click. if the users just close the form, it will save anyway

what you probably want is a decent validation test in the forms beforeupdate event.


Secondly, as a user, I would be infuriated if I lost an edit session because of a simple keying error. I would be very careful to clear a user's work for no good reason. Very unfriendly, and not necessary.