linking a form with expressions to a table

[Paul Cudmore]

Hi there I need some help,
I have made a simple one page form with some quite basic expressions on it, to calculate vat and timres that figure with a percentage amount.

It all works on the form, all the information gets updated to the underlying table but the problem is, the results fields still are showing nothing ie £0.00

I need the results as they are linked to a mail merge that is using these figures for imput in a letter.

any help would be welcome. I am using access 2000 xp

thanks
paul

 

[Ally]

Are you saying that the results are being stored in the table as well? What calculations are you using? Calculated fields shouldn't strictly be stored in tables unless they're likely to change and be meaningless / incorrect later on.

It could be that your controls with the calculations in just need requerying, in which case it would be:

Me.ControlName.Requery on the OnCurrent event.




(PS: Off the subject ... are you Paul C as in King Coel Photog?)

 

[Pat Hartman]

Since Vat can change over time, it is appropriate to store the calculated result. In the BeforeUpdate event of the FORM, put something like:

Me.TotAmt = Me.Qty * Me.Price * Me.Vat