Drop down choice changes next field options

[Guest]

I want to create a template that offers first a drop down list, and the
second field changes depending upon which selection was made from the drop
down list. Example, Drop down contains two telephone companies, if you
select Option 1, the next field offers Option 1 model numbers. If you select
Option 2, that same field offers ony option 2 model numbers, etc.

 

[Greg Maxey]

This should get you started:

http://gregmaxey.mvps.org/Linked_DropDown_Fields.htm

 

[Guest]

Hi,

I'm new here and I do not have a complete answer for you. But my problem is
similar to yours, so I'll point you to my post for what it's worth. Like I
said I'm new, but I can find my post by typing in "ericm" into the search. I
found help though at the "auto-fill the next 3 fields..." post. Type that
into the search. The result is a pointer to a macro, but it's really helpful.

I know you don't want to auto-fill, but the macro could be changed somehow
to auto-populate a dropfield depending on the other field. Hopefully others
will read this response and add to it with their knowledge.

Anyway, that's what I got.