Member Avatar for jbrown72188
jbrown72188 0 Newbie Poster

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?

  • 1 Contributor
  • 0 Replies
  • 96 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.