I have a form (frmViewAllAdjustments) that shows all billing adjustments. Some are pending review and some that are already reviewed. The subform (ARO_Adj_Details Subform) shows the related records. My goal is to make the records on the subform editable if the record of the main form has not been reviewed yet.
It seems to be unable to recognize the subform control when I attempt to reference it with VBA for the OnCurrent() function of the main form. Below is the code I used to attempt to enable one of the subform controls based on review status. It has been failing on the second line of the If statement with runtime error 2465 "Access can't find the field '|1' referred to in your expression".
If Me.ReviewApproveDenyBox.Value = "Not Reviewed" Then
Forms.frmViewAllAdjustments.[ARO_Adj_Details Subform].Form.FlatType.Enabled = True
End If
Does anyone know the correct syntax for referencing this control? I have found a few variations online but none have worked for me so far.
It seems to be unable to recognize the subform control when I attempt to reference it with VBA for the OnCurrent() function of the main form. Below is the code I used to attempt to enable one of the subform controls based on review status. It has been failing on the second line of the If statement with runtime error 2465 "Access can't find the field '|1' referred to in your expression".
If Me.ReviewApproveDenyBox.Value = "Not Reviewed" Then
Forms.frmViewAllAdjustments.[ARO_Adj_Details Subform].Form.FlatType.Enabled = True
End If
Does anyone know the correct syntax for referencing this control? I have found a few variations online but none have worked for me so far.