Databse help.

[korrowan]

Hello and thank you in advance.

I am trying to no avail to type a name in a text field such as "Mid-Penn CDC" and in another text field to have the address come up automatically so I do not have to type that in 1000 times a week. So for each mortgage lender I am trying to make the address pop up in another text field. The name of the fields are ML1, and MA1 respectively. If anyone could help me with how to create this function that would be great.

Thank you,

George

[ADezii]

Hello and thank you in advance.

I am trying to no avail to type a name in a text field such as "Mid-Penn CDC" and in another text field to have the address come up automatically so I do not have to type that in 1000 times a week. So for each mortgage lender I am trying to make the address pop up in another text field. The name of the fields are ML1, and MA1 respectively. If anyone could help me with how to create this function that would be great.

Thank you,

George

You would need to use the DLookup() Function in the AfterUpdate() Event of the first Text Box in order to find the corresponding Address. You can reference this in the Access Help file.

[korrowan]

Thank you very much I will see what I can do with that =).

[korrowan]

In this table I also have a line for an assignee which if there is an assignee the address for the assignee would have to be used. Would it be more advantageous to do this with an update query and write a check to to do the assignee then the mortgagee? And if that is the better route how would I write the check and how do would I use strings as i never have used strings before in Access in this way. I am using auto-correct so the names will ALWAYS be the same.

Kor