Form Values to Tables

[Guest]

I have a form with multiple textboxes, checkboxes, comboboxes, etc. I have
created this form in design view therefore it isn't bound to any one table,
but the data collected will need to be stored into multiple tables.

I have tabs that divide the different sections of my form(one for each
table), and a submit command button.

I am having problems getting the inputted values from the form's controls
into the corresponding fields in the tables. Is it a syntax issue? If so,
what is the correct syntax to use?

Thanks in advance

 

[Guest]

Let me be a little clearer. I can add the record valuse when I have set up
the form's record source to a corresponding table, but the form has tabs that
each have different record sources.

 

[Guest]

It's easier for us to see what you are actually trying to do if you post the
code you are having trouble with at the moment.

tonyT..