 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / October 20072 combo boxes on form
i have 2 combo boxes on my form, both combo boxes draw data from the same colum in a table. when i update one combo box the other combo box displays the same data that i updated. how can i make the combo boxes display different data from the same colum in the table? thank you.  Signaturegary Gary "different data from the same column"? I'm not understanding what it is you want to accomplish. A literal interpretation of that phrase would mean "data from some other row". Which row? How many rows are there in the table? Everything starts with the data in Access. How about if you post back with an example of the data you are using? SignatureRegards Jeff Boyce www.InformationFutures.net Microsoft Office/Access MVP http://mvp.support.microsoft.com/ Microsoft IT Academy Program Mentor http://microsoftitacademy.com/ > i have 2 combo boxes on my form, both combo boxes draw data from the same > colum in a table. [quoted text clipped - 3 lines] > the table? > thank you. im sorry jeff, im new to this and i have trouble explaining...thank you for being patient -the fields in the table that is the forms record source is a list of names in a column, (in my table i have names listed in a single column) -on my form i have 2 combo boxes labeled "name" -when using my form i update combo box #1 with the name "joe" then i update combo box #2 with the name "fred" combo box #1 instantly changes to "fred" and i want it to remain "joe" i hope i explained it right thank you gary Signaturegary > Gary > [quoted text clipped - 16 lines] > > the table? > > thank you. Gary You've explained what you are doing. Now, why? What will having two combo boxes, both looking at the same field, allow you to do? SignatureRegards Jeff Boyce www.InformationFutures.net Microsoft Office/Access MVP http://mvp.support.microsoft.com/ Microsoft IT Academy Program Mentor http://microsoftitacademy.com/ > im sorry jeff, im new to this and i have trouble explaining...thank you for > being patient [quoted text clipped - 33 lines] > > > the table? > > > thank you. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.