Referencing Subform Control property from Main Form
I have a combo box (cboWellID) on a Main Form (frmInventAssign) with an AfterUpdate Event:
Private Sub cboWellID_AfterUpdate()
If Me!txtQty = 0 Then
Me!cboWellID = Null
Forms!frmInventAssign![sfInventAsgn].[chkDploy].Visible = True
This is meant to insure that the user has indicated a Quantity to withdraw from inventory and a Well to which it is assigned before the checkbox ("chkDploy"; Visible = No) control on a subform (sfInventAsgn) becomes visible.
When the code executes it fails with this error message: