Hi all,
I have a sub form that must be visible only when a control has a certain value
and the sub form must only be visible if there is any records to display if it meets the control conditions
DAWSheetCSOrderStock only to be visible if it contains records
not sure how to code VBA.
Code Tags Added by UG
Please use Code Tags when posting VBA Code
Please feel free to Remove this Comment
https://www.access-programmers.co.u...e-use-code-tags-when-posting-vba-code.240420/
I have a sub form that must be visible only when a control has a certain value
and the sub form must only be visible if there is any records to display if it meets the control conditions
DAWSheetCSOrderStock only to be visible if it contains records
not sure how to code VBA.
Code Tags Added by UG
Please use Code Tags when posting VBA Code
Please feel free to Remove this Comment
https://www.access-programmers.co.u...e-use-code-tags-when-posting-vba-code.240420/
Code:
My Code: #
If Me.Type = "SB" Or (Me.Type = "Quality") Or (Me.Type = "Standard") Then
Me.Warranty.Visible = False
Me.DAWSheetCSOrderStock.Visible = True
Else
Me.Warranty.Visible = True
Me.DAWSheetCSOrderStock.Visible = False
End If#
Last edited by a moderator: