field with conditional viewing

  • Thread starter Thread starter papa
  • Start date Start date
P

papa

I am trying to make a form that will only allow a field
to be visible when a value of another field is equal to
either 1 or 2.

Is this possible?

TIA
 
I am trying to make a form that will only allow a field
to be visible when a value of another field is equal to
either 1 or 2.

Is this possible?

TIA
Click to expand...

Forms don't have fields, they have controls.
Code the Form's Current event:
[ControlName].Visible = ([OtherControl] = 1 or [OtherControl] = 2)

If the [OtherControl] can be changed by the user, then use the same
code in the [OtherControl] AfterUpdate event as well.
 
I stand corrected. This almost works. I have made the
[othercontrol] default to "3". However, when I am adding
a new record, and want the [controlname] to not be
visible until [othercontrol] is updated to 1 or 2. The
problem is that when I go to enter a new record, I get a
runtime error 94 - Invalid Use of Null.

I have tried putting similar events in other events but
it doesn't seem to update when going to or from a
different record with out it being in the current form -
except that doesn't work when going to a new record.

TIA

-----Original Message-----
I am trying to make a form that will only allow a field
to be visible when a value of another field is equal to
either 1 or 2.

Is this possible?

TIA
Click to expand...

Forms don't have fields, they have controls.
Code the Form's Current event:
[ControlName].Visible = ([OtherControl] = 1 or [OtherControl] = 2)

If the [OtherControl] can be changed by the user, then use the same
code in the [OtherControl] AfterUpdate event as well.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
.
Click to expand...
 
Back
Top