Results 1 to 3 of 3
  1. #1
    dccjr's Avatar
    dccjr is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    Nov 2012
    Location
    Colorado Springs, CO
    Posts
    138

    Referencing Controls on and off a Tab

    I have a form which contains 6 identification fields. On this same form I have a tab object with 8 tabs. Each tab has a series of text and combo boxes. Additionally, all tabs have a command button to "Finalize" the record to the table. Some tabs have an "Add Additional Record Set" command button for that tab. The data from each tab is being written to a different table. However, one or two of the identifying fields also get written to each table.

    I can't seen to get the syntax for the insert statement correct when referencing the identifying fields off of the tab. I would like to know how to reference these is both directions (from tab-to-form, and form-to-tab).

  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,521
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    DepricatedZero's Avatar
    DepricatedZero is offline Cthulhu Fhtagn!
    Windows 8 Access 2007
    Join Date
    Apr 2013
    Location
    Cincinnati
    Posts
    65
    As pbaldy said, disregard the tab.

    Each one is its own form - you should be fine doing form references like Forms!frmTab8.cboField

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

Similar Threads

  1. Replies: 8
    Last Post: 02-04-2013, 11:32 AM
  2. Referencing subform controls
    By cheyanne in forum Forms
    Replies: 7
    Last Post: 04-30-2012, 10:00 AM
  3. Referencing Controls on Forms
    By cbh35711 in forum Access
    Replies: 7
    Last Post: 04-05-2012, 09:04 PM
  4. Referencing a Subroutine
    By Lockrin in forum Programming
    Replies: 1
    Last Post: 02-26-2010, 10:09 AM
  5. Referencing problem
    By thegamezn in forum Forms
    Replies: 1
    Last Post: 12-09-2005, 10:13 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