Exiting a form

[Raddy]

In a form enter a value in a field on a new record.
I decide I don't want to add the record after all, so I blank the field and press enter.
Access tells me I have entered an invalid value in the field.
the only way to escape is to close Access
Why, and how do I get around this as thre will be times when a user will want to quit adding a new record?

(the same happens if I press the "back one record " key)

 

[MStef]

Try with UNDO icon.

 

[Raddy]

Is that a parameter i can set at form level to stop it happening for users?

 

[MStef]

It is an icon in the FORM VIEW toolbar.

 

[ghudson]

To undo in vba...

Me.Undo

The record is dirty once the user modifies any of the fields in the current record. You can test for that and program your functions accordingly. Search around for your quest has been asked and answered in many threads.

 

[Raddy]

Thanks - i'll try that