Larry Brister
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)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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..