[RBLampert]

I'm creating a form for a national organization that is divided into regions,
states, and chapters. There are a lot of chapters and state organizations,
far over the 25 entry limit for drop-down boxes, and I don't want to create a
drop-down box with over 200 entries if I turn off the limit. Is there a way
to link a set of drop-down boxes so that if the user selects a particular
region, in the State box, they'll only see the states that are part of that
region, and then, a second time, see only the chapters assigned to a
particular state when the state is selected?

[Doug Robbins - Word MVP]

See the final section of

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

You are going to have to get started with VBA real quick
--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"RBLampert" wrote in message
...
I'm creating a form for a national organization that is divided into
regions,
states, and chapters. There are a lot of chapters and state
organizations,
far over the 25 entry limit for drop-down boxes, and I don't want to
create a
drop-down box with over 200 entries if I turn off the limit. Is there a
way
to link a set of drop-down boxes so that if the user selects a particular
region, in the State box, they'll only see the states that are part of
that
region, and then, a second time, see only the chapters assigned to a
particular state when the state is selected?

[RBLampert]

Thanks, Doug. This looks like it'll do what I want but I really need to
study it more closely.

The one question that jumps out at me right away, however, relates to saving
the options for the various list boxes in a separate (?) Word document or
table. Is that necessary? This form will not be completed on-line
(unfortunately) or on a network but on each respondent's own PC, so there's
no way to store the table/document in some common-access location.

I suppose I could hide the table within the form itself (I don't see it
buried in the VBA code the way you did for an earlier example on the same web
page), but (either way?) that would significantly increase the size of an
already pretty large file (pushing 1MB). I have to consider that some users
of this form, which will be downloaded first, then e-mailed when complete,
are probably still on dial-up internet connections.

"RBLampert" wrote:

I'm creating a form for a national organization that is divided into regions,
states, and chapters. There are a lot of chapters and state organizations,
far over the 25 entry limit for drop-down boxes, and I don't want to create a
drop-down box with over 200 entries if I turn off the limit. Is there a way
to link a set of drop-down boxes so that if the user selects a particular
region, in the State box, they'll only see the states that are part of that
region, and then, a second time, see only the chapters assigned to a
particular state when the state is selected?

[Doug Robbins - Word MVP]

The various choices could all be hard coded into the form. Having them in a
separate document is an easy way to set them up and maintain them.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"RBLampert" wrote in message
...
Thanks, Doug. This looks like it'll do what I want but I really need to
study it more closely.

The one question that jumps out at me right away, however, relates to
saving
the options for the various list boxes in a separate (?) Word document or
table. Is that necessary? This form will not be completed on-line
(unfortunately) or on a network but on each respondent's own PC, so
there's
no way to store the table/document in some common-access location.

I suppose I could hide the table within the form itself (I don't see it
buried in the VBA code the way you did for an earlier example on the same
web
page), but (either way?) that would significantly increase the size of an
already pretty large file (pushing 1MB). I have to consider that some
users
of this form, which will be downloaded first, then e-mailed when complete,
are probably still on dial-up internet connections.

"RBLampert" wrote:

I'm creating a form for a national organization that is divided into
regions,
states, and chapters. There are a lot of chapters and state
organizations,
far over the 25 entry limit for drop-down boxes, and I don't want to
create a
drop-down box with over 200 entries if I turn off the limit. Is there a
way
to link a set of drop-down boxes so that if the user selects a particular
region, in the State box, they'll only see the states that are part of
that
region, and then, a second time, see only the chapters assigned to a
particular state when the state is selected?

[RBLampert]

Well, since, as I noted before, there isn't going to be a way for users of
the form to access a separate document, my choices remain either hide the
table in the document or hard code the sets of options. Hard coding would, I
suppose, use fewer kbytes. If I go that route, though, I'll probably have to
ask for help with the nested lists. We'll see.

Thanks for your help.

"Doug Robbins - Word MVP" wrote:

The various choices could all be hard coded into the form. Having them in a
separate document is an easy way to set them up and maintain them.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"RBLampert" wrote in message
...
Thanks, Doug. This looks like it'll do what I want but I really need to
study it more closely.

The one question that jumps out at me right away, however, relates to
saving
the options for the various list boxes in a separate (?) Word document or
table. Is that necessary? This form will not be completed on-line
(unfortunately) or on a network but on each respondent's own PC, so
there's
no way to store the table/document in some common-access location.

I suppose I could hide the table within the form itself (I don't see it
buried in the VBA code the way you did for an earlier example on the same
web
page), but (either way?) that would significantly increase the size of an
already pretty large file (pushing 1MB). I have to consider that some
users
of this form, which will be downloaded first, then e-mailed when complete,
are probably still on dial-up internet connections.

"RBLampert" wrote:

I'm creating a form for a national organization that is divided into
regions,
states, and chapters. There are a lot of chapters and state
organizations,
far over the 25 entry limit for drop-down boxes, and I don't want to
create a
drop-down box with over 200 entries if I turn off the limit. Is there a
way
to link a set of drop-down boxes so that if the user selects a particular
region, in the State box, they'll only see the states that are part of
that
region, and then, a second time, see only the chapters assigned to a
particular state when the state is selected?