adding an autofill field from another table

[loopyl00]

I have created a combo box

SELECT Vendeurs.VendeurID, Vendeurs.[Last Name], Vendeurs.[First Name] FROM Vendeurs GROUP BY Vendeurs.VendeurID, Vendeurs.[Last Name], Vendeurs.[First Name];

This successfuly returns the first name and last name, and i'm able to autofill a text box with the first name pulled from the combo box



I want to add another txt box on the form that gives me their team name. I have a FK in the Vendeurs table linked to the [teamid] in the [team table]. When I select the name in the combobox I want to autofill the team name

[ajetrumpet]

use dlookup(), or add the team name in the box's sql statement, via a join.

[anoob]

This topic interests me... what is a join? I'm go to the MS site and lookup "dlookup()" now...

[loopyl00]

Have created a query [Vendeur Equipe] which has 3 fields [VendeurID] - [Equipe] - [Last Name]

in the AfterEvent update of the combobox

Private Sub LastNameC_AfterUpdate()
Me.FirstName = Me.LastNameC.Column(2)
Me.VendeurIDtxt = Me.LastNameC.Column(0)
Me.Equipetxt = DLookup("equipe", "Vendeur Equipe", Me.VendeurIDtxt)
Me.Emailtxt = DLookup("email", "Vendeur Email", Me.VendeurIDtxt)

End Sub