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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Separate Form 0
DMax on existing record to increment serialized # fails 1
Prevent Duplicate Form Entries 0
Access 2007 Blank Record Created When Data Entry Form Is Opened. 2
Access Automatically Send a notification email once a record is added 0
Using list box adds blank record to lookup table 1
First Subform record gets modified when closing form 3
close form question 6

Back
Top