fill a field by selecting from a drop down box

[Blakeseven]

I have a table with a list of managers and their reps. In a form I have a drop down that allows me to select the rep assigned to the record. What I want to happen is when I select the rep, the manager is loaded into the manager field from the rep table into the assount table.

Thanks forthe help..

 

[Remou]

Hi
If the Row Source of your combo looks like:
[tt]SELECT Rep, Manager FROM tblRepTable[/tt]
Your textbox can have a Control Source that looks like:
[tt]=[cboRepsCombo].Column(1)[/tt]

Or check out Dlookup in the FAQs.