ComboBox_SubForms_Updating Tables

[c8tz]

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 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

 

[John W. Vinson]

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.

What is the Subform's recordsource? Just having a master link field/child link
field will not insert a new record, nor will it update an existing record. Do
you want to update the Month, GroupID and TransferAmt fields in an *existing*
record? If so, why - since that information already exists in the main table?
Or do you want the button to create a new record in the subform's recordsource
table?

John W. Vinson [MVP]

 

[c8tz]

What is the Subform's recordsource? Just having a master link field/child link
field will not insert a new record, nor will it update an existing record. Do
you want to update the Month, GroupID and TransferAmt fields in an *existing*
record? If so, why - since that information already exists in the main table?
Or do you want the button to create a new record in the subform's recordsource
table?

John W. Vinson [MVP]- Hide quoted text -

- Show quoted text -

Thanks .. I realised now though hoping it would re: masterlink/child
link insert new record
the button is to create a new record in the subform's recordsource
table.

I hope this is clear now.

Thanks for your help.

 

[John W. Vinson]

Thanks .. I realised now though hoping it would re: masterlink/child
link insert new record
the button is to create a new record in the subform's recordsource
table.

Then the button should probably execute a one-record Append query.

John W. Vinson [MVP]