Recent content by johnny_swindle

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

@GaP42 I am glad you asked if they were side by side. Inf fact, subform 2 is a subform of subform1. I am sure that this makes a difference.

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.