Setting field to visible = false

forms_are_nightmares

Registered User.
Local time
Yesterday, 20:59
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 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

Back
Top Bottom