Invisibility

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form that where I want fields to disappear and reappear when
different values are selected from a combo box. When I have the values X1
and X2 selected I would like for the other fields to become visible and when
there is a different value selected I would like for the other fields to be
invisible.

Here is my problem. I am running a macros that sets the other fields to
visible with the SetValue function. This is conditional on whether it equals
X1. I also have a function that sets them as visible if they are X2. The
problem is that when I want to make the field disappear again. I cannot set
the value to set them to false if they are not equal or "<>". This is the
operator that I have been using. It works if I am only using one value. But
when I put it so that Field1 <> X1 And X2 it does not work.

Is there a way to get around this?

Thanks,
Joe
 
I've figured it out. I had the expressions in the wrong order. I had to
have the <> before the two = expressions. I also had to have an OR not and
AND. I also ran it on "On Current" for the best results.
 
Back
Top