Then I tried a couple of others. Boy just when I think I am understanding something. I go and mess it all up.

with Me.frmCourseReviewCycleSubform
    .visible=not .visible
    .caption=iif(.Visible,"Hide Subform","Show subform")
end with

Me.frmCourseReviewCycleSubform.Visible =not Me.frmCourseReviewCycleSubform.Visible

Try this

If frmCourseReviewCycleSubform.Visible Then
    frmCourseReviewCycleSubform.Visible = False
Else
    frmCourseReviewCycleSubform.Visible = True
End If

Thanks for the fast reply but I must be making a mistake somewhere. That code did not work either

I tried to research this error but not sure what I need to check or declare

Search results for error= You used an Option Explicit statement to require the explicit declaration of variables, but you used a variable without declaring it. Explicitly declare the variable, or change the spelling of the variable to match that of the intended variable.

Check the name of your Subform object.

I did and it was right. But what I ended up just doing was removing the subform and adding it back and not it works. How very odd. Thank you for the help!

Your welcome. Glad you got it working.