How to Set First, Second, Third Columns of ComboBox to TextBoxes

[a_20120]

Problem:
1. How can I assign the First, Second, and Third columns of a Combo Box to Text Boxes through the VBA, on After Update event of the Combo Box.

2. When what you enter in the combo is not an item of that, an Error occurs. How can I control that Error and change the Error Message too.

 

[a_20120]

Request

Please Some One Solve the above Problem

 

[unclejoe]

Put this into your afterupdate event of the combo box

Me.TextBox1 = Me.ComBoBoxName.Column(0) ‘ your first column
Me.TextBox2 = Me.ComBoBoxName.Column(1) ‘your second column
Me.TextBox3 = Me.ComBoBoxName.Coulmn(2) ‘your third column

Your not inlist event, go to

http://www.fontstuff.com/access/acctut20.htm

Yes, search is the key. Google it.

Problem:
1. How can I assign the First, Second, and Third columns of a Combo Box to Text Boxes through the VBA, on After Update event of the Combo Box.

2. When what you enter in the combo is not an item of that, an Error occurs. How can I control that Error and change the Error Message too.

 

[a_20120]

Hello Mr. UnCleJoe

Thanks very well, this was what I wanted