Command Buttons & SubForms

[AJordan]

I have a a main form (frmMain) with two sub forms (frmSub1 & frmSub2). The two forms are nearly identical and contains a combo box that selects an "office name", a text box that is tied to a query through DLookup that displays the sum of the amount in the specified office, and another text box where the user enters a monetary amount.

In the main form consist a text box which displays a running total. A text box that represents ([frmSub1].[txtAmount] + [frmSub2].[txtAmount]).

I would like to create a command button that adds the entries from the sub forms as a new record to the table "tblLedger"

This allows the user to realign funds through the various office. How can I use a command button on the main form to pass the data from the sub forms?
Thanks!

 

[ajetrumpet]

I would like to create a command button that adds the entries from the sub forms as a new record to the table "tblLedger"

Either use the recordset method here, or an accmd command (use the command only if the tblLedger is the binding object of the form you are working with). Regardless of what method you use, you will have to manually copy the data that is in the controls to the new record.