link combo box

[Guest]

I have created a form which contains
districts
employees
managers
questionnaire (5 questions)

The districts are contained in a combo box (100-800). When I select a
district, I would like the manager ID to be automatically entered. Example, I
select district 500 and Manager John Doe is automatically entered.

 

[Al Camp]

Ced,
Add the ManagerID to a second column in the combo box. On the AfterUpdate event of the
combo...
(use your own control names)
ManagerID = cboDistrict.Column(1)
Combo columns are numbered 0, 1, 2, 3, etc... so District in 0 and ManagerID in 1.

 

[Guest]

Ced,
Add the ManagerID to a second column in the combo box. On the AfterUpdate event of the
combo...
(use your own control names)
ManagerID = cboDistrict.Column(1)
Combo columns are numbered 0, 1, 2, 3, etc... so District in 0 and ManagerID in 1.
--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions