If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
Form does not update formulas
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? |
#3
|
|||
|
|||
Form does not update formulas
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? |
Thread Tools | |
Display Modes | |
|
|