I have to tables in my DB:tblTeamLeaders and tblTeamMembers. Each team consists of a leader and two members, i have assigned each team a team number. I have a combo box with the list of team numbers in it. When i select a team number i would like three text boxes to automaticaly populate with the relevent team leader and team members. Hope someone can understand how to do this.
Thanx in advance.Christy

Chisty,

Check out the Orders Form on the Northwind Sample Database that came with Access. The customer Id box sounds like it might do the same function you want to do. Look at the afterupdate event procedure for "customer id". I was able to create a combo box that once you selected something other data items were filled into other text boxes.

You also might also be able to use the "Dlookup" function. Search help for examples.

Good Luck!