Results 1 to 3 of 3
  1. #1
    U810190 is offline Novice
    Windows Vista Access 2007
    Join Date
    Mar 2010
    Posts
    14

    Adding New Records to Queries that update Tables

    I have built two new user forms from queries built off of several different tables. I am not able to add new records in my user form that will update my tables.



    I want to be able to work from the forms and have the tables update as well.

    The tables update when I edit a record, but do not update with new records added via the user form

  2. #2
    llkhoutx is offline Competent Performer
    Windows Vista Access 2007
    Join Date
    Jan 2010
    Location
    Houston, Texas USA
    Posts
    373
    Your form's record source is bad.

  3. #3
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 Access 2007
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    See if this link helps at all: http://allenbrowne.com/ser-61.html

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

Similar Threads

  1. Adding of Fields in Different records
    By pcliaros in forum Queries
    Replies: 1
    Last Post: 03-17-2010, 02:31 AM
  2. Getting Info From Tables with Queries
    By SteveI in forum Queries
    Replies: 0
    Last Post: 03-01-2010, 08:33 AM
  3. adding records through form
    By Rayk in forum Forms
    Replies: 1
    Last Post: 01-09-2010, 07:55 AM
  4. queries or tables?
    By ejohns in forum Reports
    Replies: 7
    Last Post: 07-27-2009, 11:31 AM
  5. Combining like update queries
    By xcr800man in forum Queries
    Replies: 2
    Last Post: 05-20-2008, 08:36 AM

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