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)
Larry Bristersr. DeveloperAsked:
Who is Participating?
 
Dale FyeCommented:
Have you tried:

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

or something like that?
0
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
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..
0
 
Larry Bristersr. DeveloperAuthor Commented:
Perfect. Thanks
0
 
Dale FyeCommented:
glad to help.
0
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.