Results 1 to 9 of 9
  1. #1
    Lesg is offline Advanced Beginner
    Windows 10 Office 365
    Join Date
    Sep 2021
    Posts
    63

    Editable Subform


    Hi Guys,

    I have a form as part of a tabbed subform but cannot find out why I cannot add any content when using the main form:

    Click image for larger version. 

Name:	order_notes_issue.JPG 
Views:	33 
Size:	116.3 KB 
ID:	47771

    the master & child fields are bound to orderID.

    I am sure there is something simple I am missing here but cannot see it if anyone can suggest anything to check please ?

  2. #2
    Bob Fitz's Avatar
    Bob Fitz is online now Access Developer
    Windows 10 Access 2016
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,123
    Can you show us a screen shot of the relationship window.
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

  3. #3
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,186
    the subform must be linked to the key(s) on the master form via subform properties:
    link master form field
    link child form field

    one the subform is bound to the key, then you can add data.
    (and the sub table must be keyed properly)

  4. #4
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    10,626
    why I cannot add any content when using the main form:
    That means you cannot add a new main form record? If so, can you edit an existing one?
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  5. #5
    Gicu's Avatar
    Gicu is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    3,161
    Is the subform's recordsource query editable?
    Vlad Cucinschi
    MS Access Developer
    http://forestbyte.com/

  6. #6
    Lesg is offline Advanced Beginner
    Windows 10 Office 365
    Join Date
    Sep 2021
    Posts
    63
    Hi Gicu, oddly, testing the data in the SQL backend, I am unable to add any data, so a little confused here. I will create a new table and test again.

  7. #7
    Gicu's Avatar
    Gicu is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    3,161
    Does the table have a PK? When linking ODBC tables into Access if they don't have a primary key defined you are prompted to choose the unique ID for the record;if you don't the table is not editable.

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

  8. #8
    Lesg is offline Advanced Beginner
    Windows 10 Office 365
    Join Date
    Sep 2021
    Posts
    63
    Hi Vlad,

    Thanks for that, on updating. that has resolved the problem now, thank you

  9. #9
    Gicu's Avatar
    Gicu is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    3,161
    Vlad Cucinschi
    MS Access Developer
    http://forestbyte.com/

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

Similar Threads

  1. Replies: 3
    Last Post: 05-06-2020, 12:41 PM
  2. Editable textbox to update subform
    By fhickler in forum Access
    Replies: 8
    Last Post: 06-25-2019, 02:52 PM
  3. Replies: 5
    Last Post: 07-15-2014, 09:56 PM
  4. Unbound Form and Editable Subform
    By tndinnc in forum Forms
    Replies: 6
    Last Post: 04-19-2013, 05:42 PM
  5. Updatable & editable subform?
    By jfn15 in forum Forms
    Replies: 2
    Last Post: 06-21-2011, 10:35 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