values from a subform on a tabcontrol

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Dirkvw
    New Member
    • Oct 2013
    • 1

    values from a subform on a tabcontrol

    Hello,
    I have a form with a tabcontrol on it. On page_1 of that control is a subform with a (continous) form. How do I adress the fields in vba the fields on that subform. I tried everything, but it seems I always get en error. Please help me out!
    TIA
    Dirk
  • jimatqsi
    Moderator Top Contributor
    • Oct 2006
    • 1293

    #2
    Here's the reference I always use: http://access.mvps.org/access/forms/frm0031.htm

    Jim

    Comment

    • ADezii
      Recognized Expert Expert
      • Apr 2006
      • 8834

      #3
      It can get a little hairy, but in the Northwind 2007 Sample Database, the Absolute Path to the [Quantity] 'Field' in the 'Sub-Form' sbfOrderDetails on the 'Page' Order Details_Page of the TabCtlOrderData 'Tab Control' in the [Order Details] 'Form' would be:
      Code:
      Forms![Order Details]!TabCtlOrderData.Pages("Order Details_Page").Controls("sbfOrderDetails").Form![Quantity]

      Comment

      Working...