New to Access 2003 & programming.
I have created a database to calculate costing recipes the form has a couple of subforms as well.
When I change the yield in the form the subform is recalculated, but when I change the yield the calculated field goes blank & calculation appears in the bottom left & after a few seconds the fields are populated with the correct calculations.
What I would like to do is when I change the yield field the cursor is either disabled or the cursor is changed to hour glass or something else until the calculation has finished, so that the user cannot click anything else in the database.
I have been looking & pause & wait commands but these seem to pause & wait for a period of time during wish the calculation is also paused.
Hope some one can help.
I have created a database to calculate costing recipes the form has a couple of subforms as well.
When I change the yield in the form the subform is recalculated, but when I change the yield the calculated field goes blank & calculation appears in the bottom left & after a few seconds the fields are populated with the correct calculations.
What I would like to do is when I change the yield field the cursor is either disabled or the cursor is changed to hour glass or something else until the calculation has finished, so that the user cannot click anything else in the database.
I have been looking & pause & wait commands but these seem to pause & wait for a period of time during wish the calculation is also paused.
Hope some one can help.
