Form does not update formulas

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Patricia - 07 Apr 2008 15:53 GMT

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?

Reply to this Message

Golfinray - 07 Apr 2008 16:02 GMT

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.

> 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?

Reply to this Message

Klatuu - 07 Apr 2008 16:04 GMT

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.

Signature

Dave Hargis, Microsoft Access MVP

Reply to this Message