Form does not update formulas

I have a form based on a query for data entry. When you use the query for
data entry all the calculations update as you enter. When you use the form
all the calculated fields just show error until you exit the form and go back
in. How can you make the form update the calculations as you go without have
to close and reopen?

Try using a command button on the form for record save. Use the command
button wizard, find record save, enter your data and push the save button. It
should save immediately.

"Patricia" wrote:

I have a form based on a query for data entry. When you use the query for
data entry all the calculations update as you enter. When you use the form
all the calculated fields just show error until you exit the form and go back
in. How can you make the form update the calculations as you go without have
to close and reopen?

You are making two mistakes.
First, you do not store calculated values in tables.
Second, you don't do the calculations in the query. The calculations should
be done in the form and you should store only the actual values.
Do the calculations when you need to present the values to a user eiter on a
form or on a report.

Other than the error of store calculated values, calculations in queries
should be used very judiciously. They will degrade performance. I once
converted a report that had a ton of calculations in the query that took
almost an hour to run. I put the calculations in the report and it ran in
about 2 minutes.
--
Dave Hargis, Microsoft Access MVP


"Patricia" wrote:

I have a form based on a query for data entry. When you use the query for
data entry all the calculations update as you enter. When you use the form
all the calculated fields just show error until you exit the form and go back
in. How can you make the form update the calculations as you go without have
to close and reopen?