When form closes it creates a blank record in the table

  • Thread starter Thread starter MichaelJohnson168
  • Start date Start date
M

MichaelJohnson168

I have a form that links to a table called 'Suppliers'. Whenever that
form closes it automatically adds a blank record to that table. Is
there a way to prevent that from happening?


Thanks in advance
 
I have a form that links to a table called 'Suppliers'. Whenever that
form closes it automatically adds a blank record to that table. Is
there a way to prevent that from happening?
Click to expand...


If it only happens when you had the form on a new (blank) record, then
there's probably code in the form's Current event that "dirties" the record
(that is, modifies the value of one or more fields) somehow. Maybe it's
code that sets the value of some control to a default value, rather than
using the Default Value property.

It's also possible that you have code in some other form event that dirties
a blank record or somehow forces a blank record to be created, but code
dirtying the form in the Current event is the most common cause of this
problem.
 
Back
Top