Hello Jay,
Thank you so much for getting back to my question. This document will be
emailed out to the other employees in the office. So far there is about 20
different choices in the first drop list and still growing. The document is
a Bill of Lading for the trucking company that I work with and the first drop
list is a list of the customers that use us all the time and then I want to
have it so that the second drop list is a list of the different locations
accociated with the customer. At the moment, I have 1 drop list for the
customer requesting the trip (shipper), 1 drop list for who the trip is going
to (consignee) and 1 for who is paying for the trip (billed to). The list
that I would like to use for the other list is the consignee list. I hope
that this information helps you to help me.
Thank you so much,
Corinne
"Jay Freedman" wrote:
This job requires a macro. It can be either the exit macro of the
first dropdown or the entry macro of the second dropdown. The macro
has to look at the selected item in the first dropdown, and fill the
list of the second dropdown with the appropriate data.
There are a number of ways of storing the data for the second
dropdown, and the choice depends on factors such as how the form will
be used (on one PC, on a network, emailed out of the company), how
much data there is (how many items in the first list, and how many in
the second list for each one in the first), and how often the data
needs to be changed. If you can give an idea of how these factors play
in your form, I can give more specific advice.
--
Regards,
Jay Freedman
Microsoft Word MVP FAQ: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the
newsgroup so all may benefit.
On Thu, 12 Jul 2007 15:14:02 -0700, Sidneychic.Admin
wrote:
I was just wondering if any one was able to help me with this matter. i am
currently trying to make it so that I can have a list of options in one drop
down list, and depending on what gets picked there, make it so that the
options for the second drop down list correspond with the first. If this
does not make any sense, please tell me so, and I will try to explain more.
Thank You,
Corinne