I was able to solve the problem with the users who responded and with a little help from ChatGPT.
Private Sub eName_AfterUpdate()
If Me.eName = "Tour De Lis LA" Then
' Replace "SomeValue" with the value that should trigger hiding Form2
Me.tourDetails_subform.Visible = True...
I tried my hand at crafting the correct code. I am getting an error message on line one:
Private Sub eName_Change()
If Me!eName.Value = "Tour De Lis LA" Then
Forms!tourDetails_subform.Visible = ture
Else
Forms!events_subform1.Form!tourDetails_subform.Form!.Visible = False
End If
End Sub
I have two subforms on a tab. On subform 1, I have a combo box (eName) and if the value is Tour De Lis, the make subform 2 visible. I am not sure how to approach this situation.
Johnny
Hello everyone....
I have lurked on this site for a long time learning from the posts of others and decided to join.
I thank each and everyone in advance for you assistance as I become more proficient in using Access.