Populate text box with drop down

[ptrifile]

I have a simple table that has 2 fields, one is AGENTNAME and the second is DEPARTMENT. I have a drop down to choose an agents name, how do I have a separate text box populate with their coresponding department? Can someone help me?

Thanks!

Paul

 

[Remou]

If your dropdown (combobox) has the rowsource set to:

SELECT AgentName, Department FROM TheTable

You can set the textbox to:

=Me.NameOfDropdownHere.Column(1)

Note that the column count starts from zero, this is not the same as the property Column Count, which should be set to 2. You can set the column widths to, say, 2cm,0cm, if you do not wish department to show in the dropdown.

 

[ptrifile]

Remou, thank you for the help! When following your direction I get a "#Name?" in the text box....is there something im doing wrong?

Paul

 

[Remou]

Probably not. I constantly add Me, which does not work in textboxes

=NameOfDropdownHere.Column(1)

 

[ptrifile]

Thank you that worked great! however it brings me to one more question....how can i have what is populated in the text box written back to the table for that record.

Thanks again!

Paul

 

[Remou]

That would be against the rules of normalization (

http://www.r937.com/relational.html),

are you sure that you wish to do it? The information can be easily obtained from a query joining the table to the look-up.