Setting field to visible = false (1 Viewer)

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
 

forms_are_nightmares

Registered User.
Local time
Today, 09:12
Joined
Apr 5, 2010
Messages
71
I got it. Sorry. It's funny when you look as something as plain as the nose on your face, you can't see it.
 

Users who are viewing this thread

Top Bottom