Linking fields

  • Thread starter Thread starter Nowhereman
  • Start date Start date
N

Nowhereman

I am having trouble linking information from different
fields. for example: i want to set a default value in one
field, but i want that value to chance when i enter data
into another field. so if i have $400 in my amount due
field it would change to $350 when i entered $50 into my
amount paid field. anyone know how i can do this?

-Nowhereman
 
This can be done in forms, not tables. I question the reasonableness of
saving calculated values.

Your code might be something like:
Me.txtAmtDue = Me.txtPmt - Me.txtAmtDue
 
Back
Top