How To Hide selected fields in a Form 1

[hawkeye71]

Hi,
I am using Access 2000 on a Win 2K OS.
I have created a form from only ONE table.
The form contains one drop down field, which can have only two values; A or B. This drop down is also from the same table.
If I select A, the form should grey out fields C, D, and E, and I should be able to enter information in fields G, H, and I.
If I choose B from the dropdown, the form should grey out fields G, H, and I, and I should be able to enter information in fields C, D, and E.

Thanks,
Indiana

 

[KenReay]

Hi

In After update event of the drop down (MyCombo)

C.Enabled = (MyCombo="B")
D.Enabled = (MyCombo="B")
E.Enabled = (MyCombo="B")
G.Enabled = (MyCombo="A")
..etc get the idea?

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK