Auto Fill Location Details on Form?

[blu3shirt]

Hey everyone, new to the site and new to Access pretty much. Right now I am in dire need of assistance. I have stumbled through making a few new forms and tables for my new job, and have done alright so far (even if it takes me forever to do so), but there is one thing that keeps tripping me up. I just cannot figure out how to do it, even by looking at the designs and properties of other tables/forms.

Part of my form requires me to input location details. A table is setup with every City, State and Zipcode for usage on the form. Our old form was designed to auto-fill (is that even the right term?) the City and State fields upon entry of a Zipcode. These are all coming off the same table, and it works on our old form, but I cannot seem to replicate it on the new one.

I have 2 other issues with the form, and they are also both related to this auto-fill/auto-lookup hangup. Another table is set up with employee IDs, and their corresponding Last name, First name and Middle Initial. I'd like to be able to type in the ID and have the next field automatically enter the corresponding name. Similarly, I need to enter certain other data, and I would like the next field to fill in a short description of said data.

Can anyone help me or point me in the right direction? Like I said, I've pretty much made everything else work by learning from the designs of other tables/queries/forms we have, and by trial and error. But this final hitch seems insurmountable.

Thanks for your time,
Nick

 

[pbaldy]

Search on autofill, as this comes up all the time.

 

[Imdabaum]

It also could be done with the DLookup function. I've used that quite a bit and it seems to mimic the Auto-fill action pretty well.

Me.txtField= Dlookup([tableName, fieldname, condition)

I believe that is the correct syntax. You might have to check it out thought.