Hello all: I have a form with 2 subforms. Subform1 is on the many side of a one to many relationship (using tables as the record source); subform2 is based on a query using the same one to many relationship. When I check a check box on subform1, I would like the information to display on subform2 without having to leave the current record and return to it. I tried this:
Private Sub APWA_Contact_AfterUpdate()
APWA_Contact is the checkbox on subform1; frm_Company is the main form, frm_APWA_Info is subform2. No success. As I stated earlier, if I leave the current record and return to it, frm_APWA_Info is updated, but not because of the AfterUpdate event. Any and all help is always greatly appreciated. TIA.