delete an in complete record

[kevcar40]

Hi
I have a form that is bound to a table
the table fields are :- Index Auto number
op number Text
reason Text

the form has two text boxes on it to accept op number and reason
the user enters the op number then the reason

i have tried making both fields required in the table but found this
give me problems if a user had trouble remembering what they wanted to
enter

So what i am trying to do is delete the record if either of the fields
is empty

i propose to do this on the close form button

i have tried DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70
DoCmd.DoMenuItem acFormBar, acEditMenu, 6, ,
acMenuVer70

what is the best way do do this as i wan tto stop incomplete records
gettting to the table

thanks

kevin

 

[Tom van Stiphout]

On Thu, 7 May 2009 03:53:07 -0700 (PDT), kevcar40

I would make the two fields required. If user cannot supply two pieces
of information [your joke goes here] and they can hit Esc twice to
cancel the record.

-Tom.
Microsoft Access MVP