Form Fields Active or not

[Eric]

I have several fields on a form that may not be needed. I have a check box
that indicates whether or not this data is needed.

If the check box is "Yes", then I'd like the fields to become
active/enabled. If "No" then they remain inactive/disabled.

If this is possible on the fly, by using VB code on the "on change" for the
check box on the form, what would be some code I could try?

Thanks to all

 

[Allen Browne]

Eric, I just replied to another post of yours, suggesting that you probably
don't have a normalized data structure.

While it is possible to do what you are asking here (code in the AfterUpdate
event of the controls, and the Current and Undo events of the Form), it's
probably a waste of effort.

IMHO, you would be much better advised to take a deep breath, back up from
the project, and do some serious reading on 'normalization.' Once you
understand how to break the data down into related tables, most of these
problems will disappear, and you will have a much better chance of querying
your data and reporting what you need to without all this effort.

Here's a starting point:
http://allenbrowne.com/casu-06.html
http://allenbrowne.com/casu-23.html
and here's a bunch more links to read further:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html#DatabaseDesign101

 

[Eric]

Thanks Allen, that exactly what I need to do and will do it now.

Thanks, you've been a great help