Display combo box results in to fields

[Les]

I have a combo box that is a drop down where the user can select the sales
rep I need to show the sales rep on the form I also have a field called sales
rep office and it needs to be tied to the same drop down so when a rep is
selected I display his name in the sales rep field and then also display the
sales office name in the sales office field. the sales office field is
display only the rep allows them to select from the drop down only. is this
possible?

 

[Jeff Boyce]

Les

First, you won't need a separate textbox control to display the sales rep
name, since your combobox (dropdown) can do this.

If the source (RowSource) for your combobox includes the [SalesOffice] field
(let's say in the 3rd field), you can use something like:

Me!txtYourSalesOfficeTextBox = Me!cboYourSalesRepComboBox.Column(2)

in the combobox's AfterUpdate event to show the value from the 3rd field
(Access counts columns from zero ... 0, 1, 2, ...) in your textbox.

Regards

Jeff Boyce
Microsoft Office/Access MVP