![]() |
#1
|
|||
|
|||
![]() Hi, I have created a form in word with a combo box. I have set it up listing employee position numbers and want to know if I can add a formula or find a way of linking data so if a certain position number is selected it will automatically show the name of the employee without me having to set up a seperate combo box for the employee name. e.g. I select position number 0023678 from the combo box and John Smith (employee name) appears to the right of the combo box. Any assistance with this would be greatly appreciated. |
#2
|
|||
|
|||
![]()
Once you have placed a combo box, you only add a textbox or label next to it.
Then, type-in in the ComboBox_Change() function a line with a formula that having the position number as an argument returns the employee name and assigns the result to a TextBox.Value or Label.Value Hope this helps. |
![]() |
Thread Tools | |
Display Modes | |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
*Big One* feeding sql server data into MS Word 2007 forms | vafo | Mail Merge | 0 | 02-03-2010 04:49 AM |
Bold list items in a combo box | DrewB | Word VBA | 0 | 07-17-2009 11:32 AM |
VB Code.. COmbo boxes | DrewB | Word VBA | 4 | 06-10-2009 05:31 AM |
![]() |
DrewB | Word | 3 | 06-08-2009 11:29 PM |
linking or something? | boonders | Word | 2 | 01-07-2009 02:12 PM |