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
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
Why would entry into subform UNBOUND textbox affect value in main form UNBOUND textbox?
Why entering into UNBOUND textbox?
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
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
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?
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Hi Sirs,
Kindly check for me where the error is in this code.
HTML Code:DoCmd.RunSQL ("update customer set customer.paid=" & Me.Parent.txtPAID.Value & ",customer.balance =" & Me.Parent.txtCONTRACT.Value + Me.Parent.txtPAID.Value)
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.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.