Duplication of Records

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
 
S

Steve

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)
 

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

Same value written on all records automatically 2
acnewrec? 1
Report/Subform question. 5
import data from excel 2003 to a table in an existing database 2
Convert accdb to mdb, but queries and modules are not there 2
Access Command to run access, open to specific form and specific record 1
Problem updating records 2
Combo Box Value Duplication 1

Top