Need code to take values from controls and pass as a record to a table

[Jaydeebe]

I have a form with 4 tabs. The first 3 tabs take data from the user. The 4th tab displays this data for the user to confirm that it is correct. At this point I would like to pass those values as a record to a table. How can i do this? any help greatly appriciated!

 

[Mile-O]

Why don't you just bind the form to the recordset?

 

[Jaydeebe]

Why don't you just bind the form to the recordset?

Some of the fields on tab 4 (contained in a sub form) take their values from other controls on the main form by using them as the control source. Some take a value automatically as a master/child link and are indeed bound to the recordset.

If instead of this I do this -
If i make the subform from the table that I want to fill, how can I fill those bound fields from the controls on the other tabs automatically?

 

[Jaydeebe]

I've just done it. I just needed to set the defaultvalue property to reference the controls on the other tabs and keep the control source as the table fields.