Making Subform visible based on field

[dkkirk2000]

Hello,
I have a form with two subforms. I would like to hide one of the subforms when the field "CR Change Class" is Major A or B Change. This is what I got but it doesn't work

Private Sub Form_AfterUpdate()
If [CR Change Class] = "Major A Change" Then
Me.[Major A CRs Microplan subform].Visible = True
Else
Me.[Major A CRs Microplan subform].Visible = False
End If
If [CR Change Class] = "Major B Change" Then
Me.[CR Burndown Status Microplan subform].Visible = True
Else
Me.[CR Burndown Status Microplan subform].Visible = False

End If
End Sub

Thanks for the help!!

 

[jdraw]

What exactly does "doesn't work" mean?
Do you get an error message? If so, what is number and description?

 

[dkkirk2000]

it doesn't hide the subform. that's what I'm trying to accomplish

 

[jdraw]

Try

Me.refresh

just before the end sub (just a guess)

Here is a link for referencing controls that might apply