Auto-populating form

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.

Auto-populating form