Vba

[Perfac]

On the attached database, goto form f02JournalSub. Look at the second Journal, the line Discount Received, it should calculate VAT. On the VBA page, the first event. Me!VatCr05 = Me!ExclVatCr05 * Me!Vat05b

In the query the two fields that are multiplied with one another shows values. I may miss something obvious. After updating ExclVatCr05 it does not show a value in VatCr05.

[pbaldy]

Well, not all of the records have a value in Vat05b, so multiplying anything times 0 results in 0.