Please help with Form

[TotallyConfused]

I have a database that I copied for another user. However, the other user's
database main form which consists of main form and subform in datasheet view.
As the user scrolls through records, there are duplicates. I have checked
the table and the records are only listed once. Not all records are
displayed twice or three times, as you scroll through there are records that
just show once but duplicates will display at random. What would cause this?
Hope someone can help. Thank you in advance for any help you can provide.

 

[John W. Vinson]

I have a database that I copied for another user. However, the other user's
database main form which consists of main form and subform in datasheet view.
As the user scrolls through records, there are duplicates. I have checked
the table and the records are only listed once. Not all records are
displayed twice or three times, as you scroll through there are records that
just show once but duplicates will display at random. What would cause this?
Hope someone can help. Thank you in advance for any help you can provide.

Sounds like they based the subform on a Query, perhaps joining the main form's
table to the subform's table. Open the form being used as a subform in design
view; view its Properties. What's in the Recordsource property? If it's a
query, please open the query in SQL view and post it here.

The normal approach for a form/subform is to base the Form on the "one" side
table in a one to many relationship, and the Subform on the "many" side. The
linking field in the relationship is used as the master/child link field
property. Some novice think that they need to include both tables in one form
or the other, but that's rarely actually necessary.