Use a Form as Subform - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Use a Form as Subform

Juan C Rivera

4 years ago

Good morning team,
I got a thought and looking for ideas as to how to make it work. Most likely it's very easy, I just got a senior moment right now. I have a form that I like to use as a subform also. when I use it as a subform I like to make the buttons on the from visable = false. When not a used as a sub form visable = true. How is this called out in VBA and where is it placed? In the past I just made two forms but now I'm looking to make my code smaller and clean. Any thoughts out there?

V/r
Juan
LLNP

Kevin Robertson @Reply

4 years ago

You could control the visibility of the buttons when the form opens in the button that open the form.

You could also try this code.

Private Property Get HasParent() As Boolean



    On Error Resume Next

    HasParent = TypeName(Me.Parent.Name) = "String"

    Exit Property



End Property



Private Sub Form_Load()



    If HasParent Then

        Button1.Visible = False

        Button2.Visible = False

    Else

        Button1.Visible = True

        Button2.Visible = True

    End If

    

End Sub

	Juan C Rivera OP @Reply 4 years ago
Big thanks I will give this a try when I get home tonight. Big Thanks Juan

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View