1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Can't edit/add data in subform

Discussion in 'MS Access' started by madwoman, Jul 26, 2006.

  1. madwoman

    madwoman New Member

    Joined:
    Jul 26, 2006
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    0
    I have inherited a partially completed membership Access database which I
    understand was originally generated from a load of linked FoxPro tables.
    There is a form which uses multiple tabs, the first tab contains general
    membership data (ie name, age etc) and this pulls data through from the
    'Main' table in the database. Each of the other tabs includes a subform which
    shows data held in a number of different tables linked to the 'Main' table
    (eg, first tab - general data from 'Main table', 2nd tab - home addreses
    from 'Home Address' table, 3rd tab - business addresses from 'Business
    Address' table). All tables are linked to the 'Main' table through a common
    'RegisterID' field. When I open the form I can query on any of the records
    and amend and items of data on the various tabs them without any problem.
    However if I add a new record using the >* option from the record navigation
    I can add data to the first tab (ie. into the 'Main' table) but if I move to
    the 2nd or 3rd tab I am unable to edit/add data to the fields on those tabs.
    But if I save the record after completing the fields on the first tab and
    then close the form and reopen it I can then edit the 2nd and 3rd tabs, can
    you suggest how I can change the setup to allow editing/adding data to the
    2nd and 3rd tabs without having to close the form and reopen it please. I
    have checked the subforms and they are set to AllowEdit and there are NoLocks.
     
  2. shabbir

    shabbir Administrator Staff Member

    Joined:
    Jul 12, 2004
    Messages:
    15,287
    Likes Received:
    364
    Trophy Points:
    83
    This happens because there is a relationship in the data among the tables on the first tab and other tab. Something like

    Student Roll No is on first tab and marks in other tab.
    Unless you save the roll no to the tables you cannot have marks added to the corresponding tables.

    Instead of removing such relationship I would suggest to have a button to save the data in the first tab.
     
  3. madwoman

    madwoman New Member

    Joined:
    Jul 26, 2006
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    0
    Many thanks, I think I have it sussed now.
     
  4. shabbir

    shabbir Administrator Staff Member

    Joined:
    Jul 12, 2004
    Messages:
    15,287
    Likes Received:
    364
    Trophy Points:
    83
    My pleasure.
     

Share This Page