As the user scrolls through records in form view "calculating" displays in the lower left corner of the main Access window, and the scrolling pauses until calculations are completed. I assume Access is simply updating calculated fields on the form as the user scrolls through the records. It only takes a moment with an all local database, but with Backend.mdb located on network drive over 10 mps network, and Frontend.mdb on local machine, slow down is too much, even with a few dozen records in a 64 kb database. User is scrolling around to do cut and paste and such, in conjunction with inputting a new record or editing an existing one.
Since the calculations in the form create data that is very often used, should I place calculations in table, in lieu of form, and have table updated after edit session? Or is there something about how I am using the forms in Edit mode that I should be doing differently? Can I make calculations manual, with the user filling in the form and then hitting a key to do the calculations? If I were to do this, I can envision the user scrolling through records, and updating calculated fields in form at the user's discretion.
Any advise is greatly appreciated. Obviously, I am a beginner at Access. Thanks!
Since the calculations in the form create data that is very often used, should I place calculations in table, in lieu of form, and have table updated after edit session? Or is there something about how I am using the forms in Edit mode that I should be doing differently? Can I make calculations manual, with the user filling in the form and then hitting a key to do the calculations? If I were to do this, I can envision the user scrolling through records, and updating calculated fields in form at the user's discretion.
Any advise is greatly appreciated. Obviously, I am a beginner at Access. Thanks!
