Deleting a record when some compulsory fields not filled

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am not sure where to put this but it could be simpler than I think.

Most of the fields in my form are set to compulsory. I want to be able to
delete a record if not all of these compulsory fields have been filled in.
 
If required fields have no value, the record cannot be appended to the table;
therefore, it can't really be deleted. If what you are saying is you want to
clear your form, then you can use Me.Undo. Most likely, you will want to do
that in the Before Update event of the form.
 
I have a query about this because it seems I can't go to a new record even
if I fill in all fields. I am guessing the "me.undo" is clearing the record
before I can go to a new one because I am getting a "next record" error
message.
 
Back
Top