Blank Record

  • Thread starter Thread starter Roger Bell
  • Start date Start date
R

Roger Bell

I have noticed if you enter information into a field and then delete that
information and Exit the Data Base, the next time you open the form you have
blank record.

Is there any way to avoid this, apart from using the blank record for the
next set of data or deleting the blank record? These blank records tend to
build up.

Thanks for any help
 
Hi Roger,

you could put a cancel button on the form.
You would code it to undo the entry like this:

Private Sub cmdNameOfButton_Click()
If Me.Dirty = True Then
Me.Undo
End If

DoCmd.Close acForm, Me.Name
End Sub


Replace the obvious with your control name.

When you click this button, the form will close without saving that record.
(assuming that you have just one form in Single Form view)


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia
 
Thanks Jeanette,
Tried this, but it deletes the record even if there is some data in the
fields.

Have I gone wrong somewhere?

Thanks for your understanding
 
Roger Bell said:
I have noticed if you enter information into a field and then delete that
information and Exit the Data Base, the next time you open the form you
have
blank record.

Is there any way to avoid this, apart from using the blank record for the
next set of data or deleting the blank record? These blank records tend
to
build up.

Thanks for any help
Click to expand...

I think the way to avoid this is to get into the habit of using the ESC key
to undo unwanted changes instead of the delete key.

Regards,
Keith.
www.keithwilby.com
 
I have noticed if you enter information into a field and then delete that
information and Exit the Data Base, the next time you open the form you have
blank record.
Click to expand...

Well... sure. You're saving the record as specified by the user.
Is there any way to avoid this, apart from using the blank record for the
next set of data or deleting the blank record? These blank records tend to
build up.
Click to expand...

Make one or more fields Required in table design.
 
Back
Top