G
Guest
Just to start off, I know nothing about coding, so I am definitely trying to
find a way to do this using expressions or macros because I only have a few
days to finish this project (before I leave for another job) and I'm
wondering if what I want to do is even possible at this point.
So, here's what I want to do:
I am attempting to set up a new form for easier data entry into my firm's
main db which serves to hold contact and other information for hundreds of
merge documents that are already set up based on the fields and field names
already set up in the database. So, I really don't want to seperate
information into other tables from what I have now. But, I would like to be
able to set up my form so that, when the user selects one option from a list
box for a certain field, then certain subsequent fields automatically
complete with the correct corresponding information. Ie, if A, then Field 2 =
123, Field 3 = New York, Field 4 = (123) 456-7890, if B, then Field 2 = 456,
and etc. However, I have NO idea how to do this.
My first problem is, how do I even "link" for lack of a better word, the
subsequent fields to the first to create an event function. Then, is there an
event function that can pertain to another field based on selection from the
first field's list box?
And again, for those of you who can suggest coding, I really appreciate it,
but unless you can come teach it to me in the next 24 hours it probably won't
help me a whole lot, although I do appreciate ANY help I can get!!
Thanks all!!
find a way to do this using expressions or macros because I only have a few
days to finish this project (before I leave for another job) and I'm
wondering if what I want to do is even possible at this point.
So, here's what I want to do:
I am attempting to set up a new form for easier data entry into my firm's
main db which serves to hold contact and other information for hundreds of
merge documents that are already set up based on the fields and field names
already set up in the database. So, I really don't want to seperate
information into other tables from what I have now. But, I would like to be
able to set up my form so that, when the user selects one option from a list
box for a certain field, then certain subsequent fields automatically
complete with the correct corresponding information. Ie, if A, then Field 2 =
123, Field 3 = New York, Field 4 = (123) 456-7890, if B, then Field 2 = 456,
and etc. However, I have NO idea how to do this.
My first problem is, how do I even "link" for lack of a better word, the
subsequent fields to the first to create an event function. Then, is there an
event function that can pertain to another field based on selection from the
first field's list box?
And again, for those of you who can suggest coding, I really appreciate it,
but unless you can come teach it to me in the next 24 hours it probably won't
help me a whole lot, although I do appreciate ANY help I can get!!
Thanks all!!