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)
Do more with
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Have you tried:
=[cmbContacts].[column](2)
or something like that?
=[cmbContacts].[column](2)
or something like that?
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..
Premium Content
You need an Expert Office subscription to comment.Start Free Trial