Desperate for help......Would like to automate text entry...

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!!

You need to employ the 'After Update' event.
You really need vb code to do this.
Its not hard.
IF Me!ListBoxName = "Whatever" Then
Me!SomethingElse = "abc"
Me!Anotherthing = "xyz
End if
If the other controls you want to set are listboxes or combo boxes, its gets
a bit more complex.

-Dorian

"ELC" wrote:

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!!

Thank you VERY much!! I think I can handle it if it's only that much code.
Thanks again!

"mscertified" wrote:

You need to employ the 'After Update' event.
You really need vb code to do this.
Its not hard.
IF Me!ListBoxName = "Whatever" Then
Me!SomethingElse = "abc"
Me!Anotherthing = "xyz
End if
If the other controls you want to set are listboxes or combo boxes, its gets
a bit more complex.

-Dorian

"ELC" wrote:

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!!