Display/Hide a Form Control/Field Based On Another Field Value?

Hi all, I have to Combo boxes on a form. The first one I would always
like users to see. The second, however, I would like hidden if the
first box has certain values selected. So, if ComboBox1 has values of
1 or 2, I would like ComboBox2 to show as normal. If ComboBox1 has a
value of 3, I would like ComboBox2 hidden. Is there a relatively
simple way of doing this, if at all? Thanks for your help as always!

--Eric

Re: Display/Hide a Form Control/Field Based On Another Field Value?

add the following code to ComboBox1's AfterUpdate event procedure, AND to
the form's Current event procedure, as

Me!ComboBox2.Visible = Not (Me!ComboBox1 = 3)

hth


wrote in message
news:1193872061.996725.100600@z9g2000hsf.googlegroups.com...
> Hi all, I have to Combo boxes on a form. The first one I would always
> like users to see. The second, however, I would like hidden if the
> first box has certain values selected. So, if ComboBox1 has values of
> 1 or 2, I would like ComboBox2 to show as normal. If ComboBox1 has a
> value of 3, I would like ComboBox2 hidden. Is there a relatively
> simple way of doing this, if at all? Thanks for your help as always!
>
> --Eric
>

Re: Display/Hide a Form Control/Field Based On Another Field Value?

On Oct 31, 9:44 pm, "tina" wrote:
> add the following code to ComboBox1's AfterUpdate event procedure, AND to
> the form's Current event procedure, as
>
> Me!ComboBox2.Visible = Not (Me!ComboBox1 = 3)
>
> hth
>
> wrote in message
>
> news:1193872061.996725.100600@z9g2000hsf.googlegroups.com...
>
>
>
> > Hi all, I have to Combo boxes on a form. The first one I would always
> > like users to see. The second, however, I would like hidden if the
> > first box has certain values selected. So, if ComboBox1 has values of
> > 1 or 2, I would like ComboBox2 to show as normal. If ComboBox1 has a
> > value of 3, I would like ComboBox2 hidden. Is there a relatively
> > simple way of doing this, if at all? Thanks for your help as always!
>
> > --Eric- Hide quoted text -
>
> - Show quoted text -

Hi Tina, thanks for the quick response. I inserted a variation of the
code in both place, but now get a run-time error on the After Update
procedure of the combo box that says "Object doesn't support this
property or method." Did I do anything to the code that messed it up?
-->

Me!AcceptStatus.Visible = (Me!AppStatus = "No Application")

Thanks for your help,,

--Eric

Re: Display/Hide a Form Control/Field Based On Another Field Value?

well, i don't know. does it work when called from the form's Current event?
are AcceptStatus and AppStatus the names of *controls* in the form?

hth


wrote in message
news:1193918634.564164.229020@19g2000hsx.googlegroups.com...
> On Oct 31, 9:44 pm, "tina" wrote:
> > add the following code to ComboBox1's AfterUpdate event procedure, AND
to
> > the form's Current event procedure, as
> >
> > Me!ComboBox2.Visible = Not (Me!ComboBox1 = 3)
> >
> > hth
> >
> > wrote in message
> >
> > news:1193872061.996725.100600@z9g2000hsf.googlegroups.com...
> >
> >
> >
> > > Hi all, I have to Combo boxes on a form. The first one I would always
> > > like users to see. The second, however, I would like hidden if the
> > > first box has certain values selected. So, if ComboBox1 has values of
> > > 1 or 2, I would like ComboBox2 to show as normal. If ComboBox1 has a
> > > value of 3, I would like ComboBox2 hidden. Is there a relatively
> > > simple way of doing this, if at all? Thanks for your help as always!
> >
> > > --Eric- Hide quoted text -
> >
> > - Show quoted text -
>
> Hi Tina, thanks for the quick response. I inserted a variation of the
> code in both place, but now get a run-time error on the After Update
> procedure of the combo box that says "Object doesn't support this
> property or method." Did I do anything to the code that messed it up?
> -->
>
> Me!AcceptStatus.Visible = (Me!AppStatus = "No Application")
>
> Thanks for your help,,
>
> --Eric
>