Results 1 to 6 of 6
  1. #1
    Artsta is offline Novice
    Windows 10 Access 2007
    Join Date
    Aug 2019
    Posts
    2

    Displaying Single Subform Field in More Visible Way


    I am creating a database for my clients which includes a Client Table, and a Sessions table, where one Client can have many Sessions.
    I am adding notes for each Session, but it is difficult to see them in Datasheet View.
    I would dearly love to be able to select a session, and have the Comments field for that session display in a nice big text box.
    I hope the picture makes sense.
    Any help would be greatly appreciated.
    Thanks.
    Click image for larger version. 

Name:	Access-Question2.jpg 
Views:	28 
Size:	189.8 KB 
ID:	39457


  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Something like this in the current event of the subform:

    Forms!MainFormName.TextboxName = Me.Comments

    replacing the names as appropriate.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    Artsta is offline Novice
    Windows 10 Access 2007
    Join Date
    Aug 2019
    Posts
    2
    Appreciate the help. I probably should have stated that I am a complete novice so please excuse the question: Where exactly do I find the current event of the subform?

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    In the properties of the subform:

    http://www.baldyweb.com/FirstVBA.htm
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  5. #5
    Join Date
    Apr 2017
    Posts
    1,673
    You have in main form a hidden (not visible) unbound control for ID of active session in subform, and a visible unbund control with formula to display the comment of session with ID in hidden control;
    Current event of subform writes session ID of active session in subform into hidden unbond control in main form (and probably has to refresh the visible unbound control there too).

  6. #6
    Dave14867's Avatar
    Dave14867 is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Nov 2016
    Location
    Upstate NY
    Posts
    376
    All,

    This works out very well for me also. Thanks for the idea. I have the same issue with little space to show fields in subform and this solves it nicely.

    Dave

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

Similar Threads

  1. Replies: 3
    Last Post: 05-02-2018, 11:37 AM
  2. Macro for visible field in subform
    By g=2012 in forum Access
    Replies: 7
    Last Post: 09-11-2012, 02:23 PM
  3. Making subform field visible/invisible
    By Snufflz in forum Forms
    Replies: 3
    Last Post: 01-17-2011, 05:30 AM
  4. Replies: 2
    Last Post: 01-06-2011, 04:38 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