Results 1 to 5 of 5
  1. #1
    hilian is offline Advanced beginner
    Windows XP Access 2003
    Join Date
    May 2012
    Posts
    44

    Question Subform table doesn't update

    I am working in Access 2003 and have a form that is bound to a table and a subform bound to a related table. The relationship is one-to-one. The form and the subform are linked on primary key/foreign key. When I add data, it adds a record to the table bound to the main form but not to the one bound to the subform. On the main form Allow Additions and Allow Deletions are set to Yes. The Record Type is Dynaset. These properties are the same for the subform. On the subform, the Enabled property is set to Yes, and the Locked Property is No. I’ve tried reading up on linked tables, but I can’t identify what I am missing.

  2. #2
    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,716
    Please tell us about your tables and data. In plain English, what are you doing, and what do you expect to happen?

  3. #3
    hilian is offline Advanced beginner
    Windows XP Access 2003
    Join Date
    May 2012
    Posts
    44
    I am creating a form for data entry. I expect that when a user enters data in the fields in the main form and the subform, a new record will be created in each table.

  4. #4
    hilian is offline Advanced beginner
    Windows XP Access 2003
    Join Date
    May 2012
    Posts
    44
    I decided to try it a different way. I used a single form. The Record Source was a query uniting the two tables. I found that I could add records to the two tables that way, and that was what I wanted to do.
    Last edited by hilian; 07-27-2012 at 02:45 PM. Reason: Grammar

  5. #5
    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,716

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

Similar Threads

  1. Replies: 9
    Last Post: 12-18-2010, 12:51 PM
  2. Filter on subform doesn't work
    By Edwardo in forum Programming
    Replies: 6
    Last Post: 11-29-2010, 08:57 PM
  3. Update field in table after update on a subform
    By jpkeller55 in forum Queries
    Replies: 3
    Last Post: 09-30-2010, 08:02 PM
  4. Why doesn't the table & Query update?
    By U810190 in forum Forms
    Replies: 1
    Last Post: 03-29-2010, 04:07 AM
  5. Form doesn´t update with Query.
    By disturbedgod in forum Forms
    Replies: 10
    Last Post: 02-09-2010, 02:00 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