Automatic fill in problem

[Randy Barnhouse]

I am relatively new to MS Access and am trying to create
a transmittal letter template for the company I work for.
In the letter I want to be able to enter the name of the
client and it to automatically put in the address... I
know that access can do this but not sure exactly how...
If anyone can help I would greatly appreciate it.

 

[jamiec]

make the client field a combo box. set the data reference to a table (or query) of clients names. Leave the autofill property set to yes. as the user starts to type, it will fill in the remaining letters as soon as the letters uniquely matches one of the names in the referenced table.