When I open a record in my form, an add additional attachments, it creates a duplicate of the record (changing my count) but my table does not?
Is there a way to stop this?
When I open a record in my form, an add additional attachments, it creates a duplicate of the record (changing my count) but my table does not?
Is there a way to stop this?
Check the record source under your Form properties. If it is using a SELECT query it duplicates records when you add more than one attachment. If you directly refer to the table, it doesn't duplicate.