Delete a record using a form

[Guest]

Hello:
Can someone please tell me how I can gracefully delete a record from a form.

For example, if the form is in datasheet view and I click on the new record
button and start to enter data in a required field (primary key field) and
then change my mind and delete the data that was entered and then try to exit
the form, I get an error message about the required field not accepting null
values. I will keep getting this message until I enter a valid value in the
field and then delete the record.

If the form is in form view and I try to delete the record by deleting the
primary key, I get an error message and I cannot delete the record.


Is there a way to gracefully deal with the above scenarios.

Thanks,
J

 

[strive4peace]

Hi Jade,

if you press the ESCape key once, you will undo the field
you are typing in. If that is not the first field of the
record, you can press ESCape again to undo changes to the
record.

Look in the record selector box to the left of your form --
if there is a pencil instead of a filled triangle pointing
to the right, you have made changes that have not yet been
saved.

Have an awesome day

Warm Regards,
Crystal

MVP Microsoft Access
strive4peace2006 at yahoo.com

 

[Guest]

Awesome! Thank you Crystal.
J

Hi Jade,

if you press the ESCape key once, you will undo the field
you are typing in. If that is not the first field of the
record, you can press ESCape again to undo changes to the
record.

Look in the record selector box to the left of your form --
if there is a pencil instead of a filled triangle pointing
to the right, you have made changes that have not yet been
saved.

Have an awesome day

Warm Regards,
Crystal

MVP Microsoft Access
strive4peace2006 at yahoo.com

 

[strive4peace]

you're welcome, Jade happy to help

Have an awesome day

Warm Regards,
Crystal

MVP Microsoft Access
strive4peace2006 at yahoo.com