Auto-populating form

[Sinoe]

Hi,

I am new - sort of. I use to post a long time ago when I worked with Access on a daily basis.

My post today is probably already listed somewhere in the forum so please forgive me. I am trying to have my form auto-populate a field when I select an item in a drop down list in another field. Here is the deal.

1 table, TblCarrier. I want to be able to have Carrier ID auto populate in a field on a form when I select a Carrier from drop down.

TblCarrier
Carrier Name Team# Carrier ID
CarrierOne 68105 B399120001
CarrierTwo 45847 D408523003
CarrierThree 76825 F433607400
CarrierFour 15736 I470618107
CarrierFive 69316 K561432000
CarrierSix 84102 T681122100

Easy, you say. I say, how?

Thanks.

 

[pbaldy]

How about

http://www.baldyweb.com/Autofill.htm

Fyi, I moved your thread out of the introductions forum.

 

[Sinoe]

Thanks for the response, pbaldy. I certain that is the answer to my inquiry.

Have a nice day!

 

[pbaldy]

No problem, and welcome to the site by the way! Post back if you get stuck.