forms_are_nightmares
Registered User.
- Local time
- Today, 09:12
- Joined
- Apr 5, 2010
- Messages
- 71
I'm having a bit of a block as I know I've done this before.
I want to be able to open a form with certain fields hidden based on the user's selection. I have a form with a combo box that has several values from which to chose.
If the user selects value a, code would read:
If Me.search = "By Vendor" Then
DoCmd.OpenForm "frm_search", acNormal, , "[Forms]![frm_search].[exterior].visible = false"
End If
But I can't remember where to reference setting the field to false.
I know this is easy and sorry if it's a waste of time.
thanks
I want to be able to open a form with certain fields hidden based on the user's selection. I have a form with a combo box that has several values from which to chose.
If the user selects value a, code would read:
If Me.search = "By Vendor" Then
DoCmd.OpenForm "frm_search", acNormal, , "[Forms]![frm_search].[exterior].visible = false"
End If
But I can't remember where to reference setting the field to false.
I know this is easy and sorry if it's a waste of time.
thanks