Getting a form to "Grey Out" certain fields

[Chris]

I've got a table with about 20 fields in it. One of them is "Analysis
Type". There are 6 different types to choose from. I've already got
a form in my self-created switchboard that has 6 command buttons of
each analysis type, enabling the user to choose. From there, I'd like
to go to the data entry form (based of fields in the table). Where my
question lies, is is it possible to have this form, once an analysis
type is chosen, to "grey out" and lock certain fields on the data
entry form that are not pertinant to that analysis type...so that the
user cannot fill them out?

For instance, analysis type "X" needs only 4 of the 20 fields to be
filled with data, but analysis type "Y" needs 8 out of the 20 fields
to be filled, analysis type "Q" needs all fields to be filled and so
on...should this be determined in a query? Basically, I'd like the
user to select an analysis type and the data entry form pop up with
only the fields pertinant to that type being able to be filled...and
those not pertinant, be greyed out.

 

[Guest]

Chris,

You're asking a lot. How do you know that the "analysis type" options won't
be added within a period of time? That will make 'coding' a lot harder to do.
Than there is the option of the fields. With each option certain fields have
te be greyed out and others don't. It can be done but it will require a lot
of maintenance and that's not what you are looking for as a developer is my
guess?

Maurice