ComboBox_SubForms_Updating Tables

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

c8tz - 28 May 2007 02:25 GMT

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

Reply to this Message

John W. Vinson - 28 May 2007 04:12 GMT

>Hi,
>
[quoted text clipped - 22 lines]
>
>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]

Reply to this Message

c8tz - 28 May 2007 05:19 GMT

On May 28, 1:12 pm, John W. Vinson
<jvinson@STOP_SPAM.WysardOfInfo.com> wrote:

> >Hi,
>
[quoted text clipped - 33 lines]
>
> - 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.

Reply to this Message

John W. Vinson - 28 May 2007 05:56 GMT

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

Reply to this Message