Results 1 to 6 of 6
  1. #1
    Perfac's Avatar
    Perfac is offline Expert
    Windows 10 Access 2016
    Join Date
    May 2016
    Location
    Centurion Pretoria
    Posts
    618

    Subform doesnt take records

    Test 200303.zip


    On our form f01Asset we normally just tab more to add one more record if needed on the subform. It does not allow it now.

  2. #2
    Perfac's Avatar
    Perfac is offline Expert
    Windows 10 Access 2016
    Join Date
    May 2016
    Location
    Centurion Pretoria
    Posts
    618
    Please note on the form load event we set Allow additions to False, but even when I took that out it didnt work.

  3. #3
    Join Date
    May 2018
    Location
    Living in Scotland UK
    Posts
    1,557
    Hi Perfac

    A bit puzzled as to why you have all those tables with no Referential Integrity defined between any of the tables??

    Can you explain the purpose of the database?

  4. #4
    Perfac's Avatar
    Perfac is offline Expert
    Windows 10 Access 2016
    Join Date
    May 2016
    Location
    Centurion Pretoria
    Posts
    618
    Quote Originally Posted by mike60smart View Post
    Hi Perfac

    A bit puzzled as to why you have all those tables with no Referential Integrity defined between any of the tables??

    Can you explain the purpose of the database?
    This is a very small part of our database that has more than 1300 objects(tables, queries, forms and reports. To attach it I just copied the queries and tables that will make the form work. A year ago the subform in question worked now it does not as described, and as can be seen. I dont understand what you try to say about referential integrity since according to my understanding the top one always gets chosen as a default, and if it should change, but there is always an integrity selection made?

  5. #5
    Gicu's Avatar
    Gicu is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    4,101
    Hi Perfac,
    Please have a look at the attached and see the changes I made. I will let you decide how you want to deal with the error (recordset not updatable) as you cannot have both (update values onCurrent in a non-updatable form). There were many errors hidden/ bad design (linking between the form /subform had field missing in subform, you are attempting to update data in the OnCurrent event of the main form even if you open it with AllowEdits=False, formulas refer to the control source of the controls instead of the control names, etc.)

    Cheers,
    Vlad
    Attached Files Attached Files
    Vlad Cucinschi
    MS Access Developer
    http://forestbyte.com/

  6. #6
    Perfac's Avatar
    Perfac is offline Expert
    Windows 10 Access 2016
    Join Date
    May 2016
    Location
    Centurion Pretoria
    Posts
    618
    Thank you for your effort my friend Vlad. There was or is no problem with the field names. Those field names worked for a long time, and it works now as the way I sent it initially. I missed it somehow that on the main form the "Allow additions" and "Allow edits" were set to no. I changed and removed it in the VBA where we set it to be false. So the main question of this thread is solved now. I will create a new thread since on the same for there is one small other issue.

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

Similar Threads

  1. Replies: 1
    Last Post: 07-11-2018, 11:13 AM
  2. Replies: 2
    Last Post: 05-29-2018, 07:39 PM
  3. Web DB Subform drag&drop doesnt work
    By Stefan in forum Forms
    Replies: 6
    Last Post: 11-27-2012, 01:42 PM
  4. VBA Doesnt add content of subform to table
    By shabbaranks in forum Programming
    Replies: 14
    Last Post: 12-16-2011, 03:47 AM
  5. My subform doesnt refresh????? HELP!
    By LiamMurphy in forum Forms
    Replies: 1
    Last Post: 03-09-2006, 09:08 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