Results 1 to 2 of 2
  1. #1
    kmw is offline Novice
    Windows XP Access 2007
    Join Date
    May 2012
    Posts
    27

    Doubled records in a form

    I have created a form to enter new records into a table, however the form does not add only one new record. the form is doubling the amount of current records every time. An example of this would be if I had 10 records in my existing table, I would enter the one record in the form, but I get a notification that I am going to append 10 records. When I click yes, I have ten new records, creating a total of 20. What can I change to get only one new record each time?

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,652
    This thread is marked as solved. Is it, or do you still need help? Sounds like you're using SQL to add records, and you need to modify it.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. Replies: 15
    Last Post: 04-17-2012, 01:42 PM
  2. form and pop form saving to different records
    By mejia.j88 in forum Forms
    Replies: 7
    Last Post: 02-16-2012, 02:42 PM
  3. DB doubled in size after import into new DB
    By rcrobman in forum Programming
    Replies: 4
    Last Post: 04-30-2011, 02:25 PM
  4. Replies: 10
    Last Post: 01-10-2011, 07:52 PM
  5. Replies: 3
    Last Post: 03-25-2010, 12:31 PM

Tags for this Thread

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