Hi All,
I am very inexperienced on access but have set up a small database to assist with my business. I have an AfterUpdate event where when I alter a textbox on my main form it recalculates a column in a subform. It is working however it is only recalculationg the first record and not the whole form. I want to edit the "SpanishTransport" text box and then update the delivered price for every record.
Can anyone help ? Please see code below -
Private Sub SpanishTransport_AfterUpdate()
Forms![Home]![Spainavailability]![Delivered Price] = ((((((Forms![Home]![Spainavailability]![Box Price] * Forms![Home]![Spainavailability]![Quantity/Plt]) * Forms![Home]![margin]) + Forms![Home]![SpanishTransport]) / Forms![Home]![ExchangeRate]) + Forms![Home]![rhd]) + Forms![Home]![UKTransport]) / Forms![Home]![Spainavailability]![Quantity/Plt]
End Sub
Thanks,
I am very inexperienced on access but have set up a small database to assist with my business. I have an AfterUpdate event where when I alter a textbox on my main form it recalculates a column in a subform. It is working however it is only recalculationg the first record and not the whole form. I want to edit the "SpanishTransport" text box and then update the delivered price for every record.
Can anyone help ? Please see code below -
Private Sub SpanishTransport_AfterUpdate()
Forms![Home]![Spainavailability]![Delivered Price] = ((((((Forms![Home]![Spainavailability]![Box Price] * Forms![Home]![Spainavailability]![Quantity/Plt]) * Forms![Home]![margin]) + Forms![Home]![SpanishTransport]) / Forms![Home]![ExchangeRate]) + Forms![Home]![rhd]) + Forms![Home]![UKTransport]) / Forms![Home]![Spainavailability]![Quantity/Plt]
End Sub
Thanks,