Duplication of Records

  • Thread starter Thread starter PA
  • Start date Start date
P

PA

I just inherited a database, an .mdb file. We are using Access 2007 but it
had not been converted. I now notice that when a record is created in one of
the forms, the record is duplicated, so it shows up twice in the form (the
form was created in datasheet format in Access 2003). I will convert the
database, but do want to attempt to troubleshoot first.
Can anyone give me suggestions as to what I should look at.

Thank you
Paul
 
Start by opening properties of the form and see what the recordsource is,
ie, table or query. Then open the table or query and see if it contains
duplicate records. If not, then there must be some kind of code behind the
form that causes it to display duplicate records.

Steve
(e-mail address removed)
 
Back
Top