Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

MS Access 2003 bind control to anothe control

Posted on 2012-12-20
4
411 Views
Last Modified: 2012-12-20
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)
0
Comment
Question by:lrbrister
  • 2
4 Comments
 
LVL 47

Accepted Solution

by:
Dale Fye (Access MVP) earned 500 total points
ID: 38710921
Have you tried:

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

or something like that?
0
 
LVL 65

Expert Comment

by:Jim Horn
ID: 38710924
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
 

Author Closing Comment

by:lrbrister
ID: 38710946
Perfect. Thanks
0
 
LVL 47

Expert Comment

by:Dale Fye (Access MVP)
ID: 38711026
glad to help.
0

Featured Post

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Microsoft Access 97 and Delphi XE2 9 50
UK Date format in MS Access 4 19
IIF in access query 19 21
Number of records returned on a form 5 19
The new Microsoft OS looks great, is easier than ever to upgrade to, it is even free.  So what's the catch?  If you don't change the privacy settings, Microsoft will, in accordance with the (EULA) you clicked okay to without reading, collect all the…
This collection of functions covers all the normal rounding methods of just about any numeric value.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

791 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question