Results 1 to 2 of 2
  1. #1
    JrMontgom is offline Competent Performer
    Windows Vista Access 2010 32bit
    Join Date
    Sep 2012
    Location
    Vero Beach, FL USA
    Posts
    124

    How to refer to fields in subforms from Main form

    I have tried, using Allen Browne's help to refer to a field in a subform from a main form.
    The Main form is named frmCEFList and the subform is named frmCEFNames and the field is [SubFundName]. This should be simple but it eludes me so I am obviously missing something. Any help would be appreciated.

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,625
    Referring to a fieldname should pull value from the current record of subform. Is that what you want?

    I always give subform container control a name different from the object it holds, like: ctrDetails.

    In textbox on main form, try:

    =[ctrDetails]![SubFundName]

    or

    =[ctrDetails].Form.SubFundName
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Multiple subforms to one main form
    By mick3911 in forum Forms
    Replies: 8
    Last Post: 02-25-2013, 09:40 PM
  2. Refer to sub-form from main form
    By burrina in forum Access
    Replies: 3
    Last Post: 11-01-2012, 07:59 AM
  3. Replies: 1
    Last Post: 08-02-2012, 02:11 PM
  4. Refer to main form
    By terryvanduzee in forum Forms
    Replies: 3
    Last Post: 10-23-2009, 07:02 AM
  5. Replies: 0
    Last Post: 12-16-2008, 07:49 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