Deletion of a data in Sub Form to update a control in main form

cheer

Registered User.
Local time
Today, 14:26
Joined
Oct 30, 2009
Messages
222
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.
 

Users who are viewing this thread

Back
Top Bottom