ComboBox_SubForms_Updating_Tables

Hi,

I have a form such that on the main form it has:

Month
GroupID (Combo)
TransferAmt
Transfer Cmd button

On the SubForm which is linked by Month and GroupID
Month - picks up from mainform
GroupID(Combo) - picks up from mainform
TransferInAmt -

The TransferInAmt should be what is in the TransferAmt on the main
Form.
from GroupID and a TransferAmt - when I click on Transfer Cmd Button
it should update the CentralLoc file such that Month, GroupID ,
TransferAmt Fields are updated.

At the same time on the subform: TransferAmt should show in
TransferInAmt; Month;GroupID and these should update in subformTable.

At the moment not updating table.

**
Would love some steering in the right path -

Thanks heaps,

ccholai

On May 27, 8:24 pm, c8tz <ccho...@gmail.comwrote:This is not real clear.
Give us the tables and fields in the tables then give us the fields
being used in the forms:

tblTable1
Field list

tblTable2
Field list

Form 1 has these fields:
tblTable1.lngXXXID
tblTable1.lngGroupID

Form 2 has these fields:
tblTable2.lngXXXID
tblTable2.lngMonthID

Maybe this will help my feeble mind figure it out.

Cheers,
Barry
www.witstoronto.ca