placing a formula in a form field

[philbennison]

Hi all,

A nice easy one for you. I am creating a database, one of the fields is total cost. Is there an easy way to have another field, which calculates the VAT without using a query? I would like this done as soon as the total is entered.

I have done this using a query, but didnt like this way.

I am sure there must be a very simple way of doing this but it has escaped me.



Help


Phil

 

[Shadez]

Tripple post thats a new one..

Just set the control source of a textbox = [the totals text box] + ([the totals text box] * 0.175)

 

[RichO]

It's actually a quadruple post.

Phil, you should edit your duplicate threads and delete them. Only yourself or a moderator can do that.