Connecting Tech Pros Worldwide Forums | Help | Site Map

ComboBox_SubForms_Updating_Tables

c8tz
Guest
 
Posts: n/a
#1: May 28 '07
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.
Quote:
>From the Main Form: I should be able to enter a month, put in a group
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


Barry Edmund Wright
Guest
 
Posts: n/a
#2: May 30 '07

re: ComboBox_SubForms_Updating_Tables


On May 27, 8:24 pm, c8tz <ccho...@gmail.comwrote:
Quote:
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.
>
Quote:
From the Main Form: I should be able to enter a month, put in a group
>
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
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




Closed Thread