Results 1 to 4 of 4
  1. #1
    brow1726 is offline Novice
    Windows XP Access 2007
    Join Date
    Dec 2012
    Posts
    13

    Query creating records *2 of whats in database

    I have an append query that is creating multiple records in the record set. I am wondering what would be causing this? It's a simple append query saving from a form to a to a record set. I am using a list box, if that makes a diffrence. This is my first use of list boxes in a form so maybe it has something to with that. Any help is greatly appreciated. Thanks!!

  2. #2
    ssanfu is offline Master of Nothing
    Windows XP Access 2000
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    You probably don't have a criteria set in the query. Why are you using an append query to save data from a form.

    Need more info. you haven't provided the SQL of the query, the controls on the form or what you are trying to do. Please explain.

    Never mind.

    I just saw your post where Paul was helping you.
    https://www.accessforums.net/forms/m...xes-30707.html

    You should stay with one thread instead of multi-posting. Posting several times about the same topic wastes everyone's time.

  3. #3
    brow1726 is offline Novice
    Windows XP Access 2007
    Join Date
    Dec 2012
    Posts
    13
    OK will do sorry I'm new to this. But my problem has changed from that set because I have decided to go with a list box instead. when I try to append data from the list box it is adding multiple fields.

  4. #4
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,870
    Suggest it would be helpful if you told us in plain English what exactly you are trying to do.

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

Similar Threads

  1. Replies: 7
    Last Post: 09-10-2012, 03:40 PM
  2. Replies: 1
    Last Post: 05-17-2012, 02:41 PM
  3. Creating query to print specific records
    By halt4814 in forum Forms
    Replies: 4
    Last Post: 05-15-2012, 08:23 PM
  4. Creating a query to display a weeks records
    By shabbaranks in forum Queries
    Replies: 16
    Last Post: 01-05-2012, 09:27 AM
  5. Replies: 6
    Last Post: 09-01-2010, 03:12 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