Link to home
Start Free TrialLog in
Avatar of Karen Schaefer
Karen SchaeferFlag for United States of America

asked on

Refresh multiple layered subform on update of checkbox

I have a multi-layered subform.  If the user Click the inactive field = true.  then I need to refresh current subform and also the subform containing the inactive list of records (another subform on the Master Subform).  since both subforms are using the same query expect where Inactive = false or true.

I have tried the following however, running into an error.  i verified the form names and even used the Expresssion builder to set the sourceobject values.

Private Sub Active_AfterUpdate()
If Me.Active = True Then
   ' Forms![frmNotesMain]![FrmNotes_MasterMain].Form![frmNotes_Master_Sub].Requery
    Forms![frmNotesMain]![FrmNotes_MasterMain].Form![frmNotes_MasterInActiveOnly_Sub].SourceObject _
        = Forms![frmNotesMain]![FrmNotes_MasterMain].Form![frmNotes_MasterInActiveOnly_Sub]
End If
End Sub

Open in new window


what am I missing.  Getting type mismatch issue - boy do I have this error message it never means what it really stands for.

Thanks,

K
ASKER CERTIFIED SOLUTION
Avatar of Gustav Brock
Gustav Brock
Flag of Denmark image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Karen Schaefer

ASKER

Thanks for the input, however, this project was cancelled I no longer need assistance with this issue.