Linking fields

[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

 

[Duane Hookom]

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