Update of Textbox in Main form from Subform Textbox afterupdate

[jgitaunjoroge]

Dear Members,



How to i update unbound textbox in main form with a unbound textbox in subform afterupdate.
For example i want to update Total amount paid, balance etc after txtamount textbox is updated.

Thanks,
Njoroge Joseph

[June7]

Why would entry into subform UNBOUND textbox affect value in main form UNBOUND textbox?

Why entering into UNBOUND textbox?

[jgitaunjoroge]

Attached is the database. Am trying to work on customer form which contains a subform called Customertrans subform. When i update amount this is expected to reflect in the main form in amount paid, balance etcJOB SYSTEM.zip

[June7]

Balance should not be a field in table. This should be calculated when needed. What is Balance supposed to be - the sum of records in subform?

Options for summing subform records:

1. Use the Totals button from the ribbon to activate a Totals row on the Datasheet view subform

2. Textbox in subform footer with expression to sum records: =Sum([Amount]). It won't show in Datasheet view but textbox on main form can reference it: =[Customertrans subform].[Form].[tbxTotal]


Why are the main form controls UNBOUND?

[jgitaunjoroge]

Hi Sirs,

Kindly check for me where the error is in this code.

DoCmd.RunSQL ("update customer set customer.paid=" &  Me.Parent.txtPAID.Value & ",customer.balance =" &  Me.Parent.txtCONTRACT.Value + Me.Parent.txtPAID.Value)

[June7]

Need WHERE clause that specifies which customer record to edit.

I would use CurrentDb.Execute instead of DoCmd.RunSQL

However, action SQL should not be necessary to save data into record already displayed on form.

Again, saving aggregate data is usually a bad design.