auto-updated fields in tables...

  • Thread starter Thread starter nale
  • Start date Start date
N

nale

Hi all, beginner question:

How can I set up a field in a record to do automatic calcuations?

For example, I have a table with products and prices in different
currencies:

---------------------------------------------------------------------
ProductID -- Product name -- Price USD -- Price GBP -- Price Euros
---------------------------------------------------------------------


What I want to do is to fill just the prices in dollars (USD) and the
other fiels to be automatically converted to pounds and euro, doing
some calculation with the field in USD...How can I do that?

Best regards
 
nale said:
can be done using macros, or VB code? how???
Click to expand...

You can only do something like this in a form, not a table. In the AfterUpdate
event of the dollars control you would run code to calculate the other values
and populate those controls.
 
Back
Top