Results 1 to 3 of 3
  1. #1
    lmac101 is offline Novice
    Windows XP Access 2007
    Join Date
    Oct 2010
    Posts
    2

    Can add only 1 attachment to a record in a form?

    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?

  2. #2
    tap50 is offline Novice
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Oct 2010
    Posts
    1
    Quote Originally Posted by lmac101 View Post
    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?
    I would like to know if this is possible too. Why does it do this?

    Todd

  3. #3
    Join Date
    Nov 2010
    Posts
    1
    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.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. attachment help!
    By ninachopper in forum Access
    Replies: 1
    Last Post: 08-01-2010, 12:03 AM
  2. Attachment help in sub-form in Access 2007
    By turnertj in forum Forms
    Replies: 1
    Last Post: 06-28-2010, 01:40 PM
  3. How do I insert an attachment using a form?
    By mitcheljp in forum Access
    Replies: 1
    Last Post: 06-18-2010, 08:53 AM
  4. Replies: 0
    Last Post: 05-04-2010, 06:39 AM
  5. Replies: 3
    Last Post: 06-27-2009, 03:53 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums