MS Access 2003 bind control to anothe control
I have a textbox that's bound to the selected item (column 2) of a combo box.
Is there any way to string together several columns?
I currently have this.
=[cmbContacts].[column](2)
Is there any way to string together several columns?
I currently have this.
=[cmbContacts].[column](2)
Who is Participating?
Explain in more detail what you mean by 'several columns'.
You can have other text boxes, where in the AfterUpdate event of the combo box you have VBA code that goes something like this:
With me
.txt_name = Me.cmbContacts.column(0)
.txt_address = Me.cmbContacts.column(1)
.txt_city = Me.cmbContacts.column(2)
end with
you get the idea..
You can have other text boxes, where in the AfterUpdate event of the combo box you have VBA code that goes something like this:
With me
.txt_name = Me.cmbContacts.column(0)
.txt_address = Me.cmbContacts.column(1)
.txt_city = Me.cmbContacts.column(2)
end with
you get the idea..
Question has a verified solution.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
All Courses
From novice to tech pro — start learning today.
=[cmbContacts].[column](2)
or something like that?