I created a database by designing my tables and then
using the form wizard to produce my forms. However when
I enter info. into the form, although it works great in
the form, it will not post the information to the
corresponding table. Example below.
Amount Owed: =[Feet]*.15
Change: =[Amount Paid]-[Amount Owed]
These calculate fine and the form works great except that
the info does not show up on the form.
The fields are set to Currency, and not indexed. I
entered the expressions above in the form design screen
by selecting the box, right clicking, selecting
properties and ...