Return to previous record on undo

[Guest]

Hi, I'm hoping someone will be able to assist me with a problem. I have a
form where a user enters information on requisitions. The textbox for the
requisition number is bound to the field ReqNum which is the primary key for
the underlying table.

I had an occasion where a user started to enter information into the text
box, hit the escape key and then tried to navigate to a different record,
which triggered an error message warning them that they could not save a
record with a null value in the primary key field.

I would like to set up the form to reset to the previous record should this
situation arise in the future. Any suggestions?

--
Cheers

Klingon Coder

"Ancient Klingon Proverb - Act and you shall have dinner, Think and you
shall be dinner"

 

[Michel Walsh]

Hi,


Me.Undo should cancel the record appending try, without trying to save the
new record effectively to be undone.


Hoping it may help,
Vanderghast, Access MVP