asked on 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)
Microsoft AccessMicrosoft DevelopmentMicrosoft Applications
Last Comment
Dale Fye
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Perfect. Thanks
glad to help.
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..