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).