Combo Box - Displaying multiple bound columns in text boxes
Posted on 2009-04-30
Hey all. I searched previous questions and found some simular to mine, but none really helped me.
I have a form running off a qry (qryTroubleTracking). Inside qryTroubleTracking I have mulitple tables linked pulling data from different areas into one main table (Trouble Tracking). One particular table linked to my main table (Trouble Tracking) is 'Opp Center Specialist'. In Opp Center Specialist table I have three columns - Old Acct ID, Specialist and MDMA Analyst. A specific Old Acct ID number is linked to specific Specialist and MDMA Analyst.
With that said, on my form, when I select a number (Old Acct ID) from my combo box, I want the corresponding names to populate in two different text boxes. One for Specialist and another for MDMA Analyst. I've tried different suggestions from other topics, but cannot get the code or tips to work. All I can get it to do it show me an error message or have both text boxes show the same name. lol