Combo Box Question

  • Thread starter Thread starter Javster095
  • Start date Start date
J

Javster095

I'd like to create a combo box... when selecting an item from the combo box
information would populate in several other textboxs.

Ex:

From the drop down menu (Combo Box) "Name" I would select John Smith.

When selecting "John Smith"... I'd have other textboxes entitled "AGE",
"Wieght" and "Height" etc. populate with text from my table.

Please assist.

Javi
 
I'd like to create a combo box... when selecting an item from the combo box
information would populate in several other textboxs.

Ex:

From the drop down menu (Combo Box) "Name" I would select John Smith.

When selecting "John Smith"... I'd have other textboxes entitled "AGE",
"Wieght" and "Height" etc. populate with text from my table.

Please assist.

Javi
Click to expand...

Here is one method.
Add unbound text control to the form.
Code the Combo Box AfterUpdate event:

Me.[ControlA] = Me.ComboName.Column(1)
Me.[ControlB] = Me.ComboName.Column(2)
etc.

Combo box columns start 0, so Column(1) is the 2nd column.

Note: I hope the actual name of the field is NOT "Name".
Name is a reserved Access/VBA/Jet word and should not be used as a
field name.
For additional reserved words, see the Microsoft KnowledgeBase article
for your version of Access:

109312 'Reserved Words in Microsoft Access' for Access 97
209187 'ACC2000: Reserved Words in Microsoft Access'
286335 'ACC2002: Reserved Words in Microsoft Access'
321266 'ACC2002: Microsoft Jet 4.0 Reserved Words'

For an even more complete list of reserved words, see:
http://www.allenbrowne.com/AppIssueBadWord.html
 
Back
Top