954,566 Members — Technology Publication meets Social Media
Username:
Password:
Lost login information?
Have something to say? Contribute New Article Reply to this Article

Auto-fill from Combo Box

I have a simple form in which i have a contact name combo box. The combo box gets info from a querry (name, contact number 1, contact number 2). I want the name to display in the combobox (which it does) and then contact # 1 and 2 to display in a seperate textbox. I had it working but now it doesnt seem to want to work. Below is the code i have:

CboContacntName_AfterUpdate()

Me.txtOfficePhone = Me.cboContactName.Column(2)
Me.txtLabPhone = Me.cboContactName.Column(3)

End Sub

For some reason, the fields stay blank. Any ideas?

jbrown72188
Newbie Poster
1 post since Sep 2010
Reputation Points: 10
Solved Threads: 0
 

This article has been dead for over three months

Post: Markdown Syntax: Formatting Help
You
View similar articles that have also been tagged: