Calculations

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

stevoo - 08 May 2007 02:38 GMT

Can we multiply two fields from two different forms without using a query.
Example from one table the value and from the second table the VAT(in order
when the VAT changes
to amend only the VAT field)
When I try it I'm getting error message.
Thanks

Reply to this Message

Arvin Meyer [MVP] - 08 May 2007 04:49 GMT

Why not use an unbound combo box to select the VAT tax rate on 1 form. Then
you can multiply it in the AfterUpdate event of the combo. Alternatively it
the VAT combo is bound to the table, if you are not using a continuous form
or datasheet, you can just multiply the numbers as the control source of an
unbound textbox.

Why would you not want to use a query though?

Signature

Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

> Can we multiply two fields from two different forms without using a query.
> Example from one table the value and from the second table the VAT(in
[quoted text clipped - 3 lines]
> When I try it I'm getting error message.
> Thanks

Reply to this Message