I made a simple Access table.
I then made a form based on the table, to fill it in.
I put an expression in the form to calculate one field, based on the previous field (I enter a date, and it calculats the Fiscal Year the date falls into)
The form works. If I call up an existing record, it correctly shows the FY on the form. If I add a new record, it correctly shows the FY on the form.
However, it never puts the FY value back into the table! It will correctly enter all the other fields into the table, but leaves the FY field blank.
Of course, to put in the calculation (expression) I changed the control source on the form field from the name of the field in the table, to the expression.
How do I get it to enter the calculated value into the table?
Start Free Trial
