Using a combo box selection to disable or hide groups of fields

[Breeves22]

Good afternoon.



I am fairly new to access and although i have managed to figure out most of the basics myself there are still some things that i require aid with and i am hoping someone here can help me.

I have created a form to monitor our cases at work and in that form there is a combo box which displays the type of work it is (simple, complex, Stairlift).

Further down the form i have the works progress sections for the three types of works. Each works progress section contains fields for dates relating to when each action is done and the next needs to be done by.

I have grouped all the fields in each section together to make it easier.

What i would like to do is be able to select an item in the combo box (for example Simple) and then either disable or hide the works progress groups for Complex and Stairlifts. Leaving only the fields my users will need to fill in.

Thankyou for your time

[NTC]

in the AfterUpdate event of that combobox, put your code to make other controls not visible: i.e.

me.ControlName.visible=false

just stack as many as you want there.

keep in mind that you may need to reverse that state also - if so, consider the OnCurrent event of the form's property itself.

Hope this helps.