Sums not done only on page 1 of report

[shay]

Hi

I have a report which prints invoices. There are some simple sums in the code behind the report (Report_Page) to calculate the VAT due (some invoices are for people outside the UK who don't pay VAT).

The numbers look fine apart from the first invoice ie it doesn't do the sums until page 2 of the report.

Have I put the code in the wrong event? Can anyone think of a solution?

TIA

shay

 

[Rich]

Why not just use a calculated control instead of VBA?

 

[shay]

Thanks for the reply.

I opted for VBA because there are 4 things that need to happen depending on whether the customer is in the UK, European Union or elsewhere.

shay

 

[Rich]

Which event are you using, post the code