Form Question, if/then or conditional formating

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

Guest

On my form, I have a field called type. It contains items like desk, chair,
etc. I would like if you sellect desk, that it would gray out any other field
on the form that is not associated with desk. Same if you select chair, etc.
Is this possible?
Thanks for the help in advance.
 
Use the Enabled property of the controls you want to grey out.

As to naming, Type is a bad name to use because Type is also a property of
some collections and objects.
 
In the oncurrent event (and after update event) then you want to put
all you code to enable whatever fields you want enabled. Be sure to
both enable and disable each field otherwise they will not get
re-enabled properly.

Question that you need to consider. If they put in Desk and then fill
on some fields that relate to desk but then change to chair, what are
you going to do about the erroneious information that is now in the
desk related fields?
 
Back
Top