hands off!! restrict options.

Pete Morris · Oct 3, 2003

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 · Oct 3, 2003

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 · Oct 3, 2003

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

Mile-O · Oct 3, 2003

Have a look at this example:

hands off!! restrict options.

Pete Morris

Registered User.

Mile-O

Back once again...

Pete Morris

Registered User.

Mile-O

Back once again...

Attachments

Similar threads

Users who are viewing this thread