S
short
I am having issues trying to figure this out and I'm hoping someone here can
help.
I have four forms that are all based off of a query. One is software, basic
information about the software while the other three are the complete
information about that software. I'll call them softwareA, softwareB,
softwareC.
What I want to be able to do is in software there is a entry called name,
where the user types in any of the three software names. I want that form to
come up. Now, I did it where the tables were all visible and then would come
up when the user types it in. But once the user is finished and wants to type
in a new software information, that softwarA etc.. table does not disappear.
Here's the code I have:
Private Sub Software_Name_AfterUpdate()
'These will only open the form that is needed. S/as softwareA when the user
types in the choice
If Software_Name.Text = "SoftwareA" Then
Me.SoftwareAForm.Visible = True
ElseIf Software_Name.Text = "SoftwareB" Then
Me.SoftwareBForm.Visible = True
ElseIf Software_Name.Text = "SoftwareC" Then
Me.SoftwareCForm.Visible = True
Else
Me.SoftwareAForm.Visible = False
Me.SoftwareBForm.Visible = False
Me.SoftwareCForm.Visible = False
End If
End Sub
Is there a way to clear these forms back to not visible? or should I do pop
ups?
Thanks
help.
I have four forms that are all based off of a query. One is software, basic
information about the software while the other three are the complete
information about that software. I'll call them softwareA, softwareB,
softwareC.
What I want to be able to do is in software there is a entry called name,
where the user types in any of the three software names. I want that form to
come up. Now, I did it where the tables were all visible and then would come
up when the user types it in. But once the user is finished and wants to type
in a new software information, that softwarA etc.. table does not disappear.
Here's the code I have:
Private Sub Software_Name_AfterUpdate()
'These will only open the form that is needed. S/as softwareA when the user
types in the choice
If Software_Name.Text = "SoftwareA" Then
Me.SoftwareAForm.Visible = True
ElseIf Software_Name.Text = "SoftwareB" Then
Me.SoftwareBForm.Visible = True
ElseIf Software_Name.Text = "SoftwareC" Then
Me.SoftwareCForm.Visible = True
Else
Me.SoftwareAForm.Visible = False
Me.SoftwareBForm.Visible = False
Me.SoftwareCForm.Visible = False
End If
End Sub
Is there a way to clear these forms back to not visible? or should I do pop
ups?
Thanks