Prodriguez
New member
- Local time
- Tomorrow, 06:40
- Joined
- May 1, 2013
- Messages
- 11
Dear all,
I have attached an example of a database that has an invoice form linked to a invoice line sub-form.
Once the amount is updated in the invoice line the tax amount is calculated by multiplying the amount with the tax rate in the combo box of the parent form. So this works very well when I am adding one line at a time in the subform.
By using VBA I would like to update the tax amount field of all the records linked to the current invoice being displayed if I decide to update later the tax rate in the combo box (after update event in the combo box)
Thank you in advance for your comments.
I have attached an example of a database that has an invoice form linked to a invoice line sub-form.
Once the amount is updated in the invoice line the tax amount is calculated by multiplying the amount with the tax rate in the combo box of the parent form. So this works very well when I am adding one line at a time in the subform.
By using VBA I would like to update the tax amount field of all the records linked to the current invoice being displayed if I decide to update later the tax rate in the combo box (after update event in the combo box)
Thank you in advance for your comments.