hands off!! restrict options.

[Pete Morris]

I would like to restrict the options available in field 2 based on the selection of field 1.
Would vba code be required in the "after update" field?

Would it be an if statement?

if a is selected then 1,2,3,4?
if b is selected then 5,6
etc, etc...??

I would really appreciate guidanance on this.

Thanks, nice but dim Pete.

 

[Mile-O]

Is this a cascading combo box solution you would like?

Or is the restriction based off another type of control? i.e. listbox, option group, etc

 

[Pete Morris]

I guess its a cascading combo box solution.
select item from 1st combo box which limits choices in second combo

 

[Mile-O]

Have a look at this example: