duplicate records

  • Thread starter Thread starter ASP
  • Start date Start date
A

ASP

each time i enter a record to my subform it automatically gnerates an
empty row in the table.Help pls!!
 
In which table? The parent table or the child table? Could you give more
specifics on what is happening?
 
It sounds like you have code in one of the events of the subform that
contributes this extra record.

Particularly, look out for anything in the Current event of the form, or its
AfterUpdate or AfterInsert events.

You can prevent the blank record from being accepted by opening the
subform's table in design view, and setting the Required property for one of
the fields to Yes. This might also give you a clue as to when the bad record
is being created.
 
You must log in or register to reply here.

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

Autonumber is reusing previously assigned numbers-creating duplica 3
How to create a duplicate record on the next row 13
Main \ Sub Form Data 1
Automatically highlight duplicate value 1
new subform entry for existing record 3
Duplicate Subform and SubSubForm Records but not Main 1
Duplicate Form, Subfrom 1
Disappearing records in datasheet view 1

Back
Top