MS Access 2003 bind control to anothe control

Larry Brister
Larry Brister used Ask the Experts™
on
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)
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Owner, Dev-Soln LLC
Most Valuable Expert 2014
Top Expert 2010
Commented:
Have you tried:

=[cmbContacts].[column](2) & " " & [cmbContacts].[column](3)

or something like that?
Jim HornSQL Server Data Dude
Most Valuable Expert 2013
Author of the Year 2015

Commented:
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..
Larry Bristersr. Developer

Author

Commented:
Perfect. Thanks
Dale FyeOwner, Dev-Soln LLC
Most Valuable Expert 2014
Top Expert 2010

Commented:
glad to help.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial