I have a main form call frmARSystem. On top of this form, there is one text box [txtPrice] and one sub form [subForm_ARSystem]
When user press the delete KEY and remove one row of data in the subForm_ARSystem, I want the txtPrice on the main form ARSystem to be updated accordingly.
I have tried the following but it doesn't work :-
1) Having the event "AfterUpdate" at both the main and subform
2) Having the event "Dirty" at both the main and subform
The method I have used to refresh the main form is REQUERY. No syntax error is detected and the only thing is the txtPrice is not updated after deletion is done.
When user press the delete KEY and remove one row of data in the subForm_ARSystem, I want the txtPrice on the main form ARSystem to be updated accordingly.
I have tried the following but it doesn't work :-
1) Having the event "AfterUpdate" at both the main and subform
2) Having the event "Dirty" at both the main and subform
The method I have used to refresh the main form is REQUERY. No syntax error is detected and the only thing is the txtPrice is not updated after deletion is done.