Prev: XP & Vista & Win 7 My Doc Directory Structure.
Next: db backend upgrades
From: dabears56 on 20 Mar 2010 16:23
I want my combo box to autopopulate two fields in form. Is that possible?

From: Linq Adams via AccessMonster.com on 20 Mar 2010 16:43
Sure! Set up your combobox using the wizard and include the fields you need,
from Left-to-Right.

If in the Combobox they appear as

Field1 Field2 Field3

then the code would be

Private Sub YourComboBoxName_AfterUpdate()
Me.txtField1 = Me.YourComboBoxName.Column(0)
Me.txtField2 = Me.YourComboBoxName.Column(1)
Me.txtField3= Me.YourComboBoxName.Column(2)
End Sub

Notice that the column index is zero based.

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/201003/1

 | 
Pages: 1
Prev: XP & Vista & Win 7 My Doc Directory Structure.
Next: db backend upgrades