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 Removed)


"PA" <(E-Mail Removed)> wrote in message
news:68ADAFB0-639C-4EB3-8941-(E-Mail Removed)...
>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