InvisibleMan
asked on
Inputting Text into a Bound Dropdown Control Help.
I have a bound dropdown box. It is bound as follows:
Rowsource - bound to ADODC Control
ListField - to field
BoundColumn - to field
I need this to stay as is, however on a certain condition I have to fill it with text that is not in my bound rowsource. I am trying just saying control.text but its not filling it. I also tried control.boundtext.
I tried setting the Rowsource = "" and I got an error. Any help please.
Rowsource - bound to ADODC Control
ListField - to field
BoundColumn - to field
I need this to stay as is, however on a certain condition I have to fill it with text that is not in my bound rowsource. I am trying just saying control.text but its not filling it. I also tried control.boundtext.
I tried setting the Rowsource = "" and I got an error. Any help please.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
is this in VB6 or MS Access VBA? There is a SIGNIFICANT difference.
Good point, Arthur.
ASKER
VB6
ASKER
The problem is I need this as a Dropdown list. I add the items with the loop and then I want to based on a selection from a dropdown list above it fill this dropdown list with this items as well and have it selected.
So, you have 2 comboboxes say cboState and cboCity and cboCity is pre-populated but when cboState has an entry selected you want it to add (but not remove the existing - at least in the eyes of the user) new choices to cboCity? Just thought I'd clarify before offereing answer...
ASKER
Yes Robert and then I want that value selected in the dropdown list.
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!
I am in the process of cleaning up the questions for this member as this member has failed to take care of their opened questions
Experts, please leave your recommendations within the next 3 days.
Without recommendations, I intend to come back here on 2/26/2003 and:
delete with NO refund
InvisibleMan,
You have 16 opened questions and have been asked to take care of them previously. If you wish to keep your account in good standing, please take care of these questions prior to 02/26/2003.
Failing this, your account will be reviewed by a site administrator at that point. I am posting this in ALL 16 opened questions and have submitted a cleanup request in community support.
https://www.experts-exchange.com/questions/20439569/Need-help-with-creating-a-word-template-and-some-simple-fields.html
https://www.experts-exchange.com/questions/20453889/Making-a-image-or-picture-visible-with-code-Tough-Question-need-a-smarty.html
https://www.experts-exchange.com/questions/20388128/Unable-to-Log-On-to-Provider-SQLOLEDB-1.html
https://www.experts-exchange.com/questions/20343921/GREAT-PLAINS-DYNAMICS-HELP-Integration-Manager.html
https://www.experts-exchange.com/questions/20273575/DATABASE-SIZE-SHRINKING-AND-LOG-FILE-QUESTION.html
https://www.experts-exchange.com/questions/20480517/Crystal-Reports-Sum-Question-on-Amount-Field-Help-Please.html
https://www.experts-exchange.com/questions/20475331/Inputting-Text-into-a-Bound-Dropdown-Control-Help.html
https://www.experts-exchange.com/questions/20409250/Opening-Excel-File-modifying-column-width-then-saving-it-in-VB.html
https://www.experts-exchange.com/questions/20336887/Visual-Basic-Grid-Help-Different-fields-from-different-sources.html
https://www.experts-exchange.com/questions/20327829/How-to-know-what-the-latest-DLL-is-registered-on-server.html
https://www.experts-exchange.com/questions/20324132/Class-Modules-and-VB-Application-Question.html
https://www.experts-exchange.com/questions/20390261/Creating-a-HTML-Email-Feedback-Form-Can-it-be-done.html
https://www.experts-exchange.com/questions/20403544/PDF-Files-previously-on-the-Web-allowed-data-entry-now-it-does-not-Help.html
https://www.experts-exchange.com/questions/20519637/Tab-Pages-Not-Ordering-Right-on-Tab-Page-Driving-me-nuts-Help.html
https://www.experts-exchange.com/questions/20457825/Strange-Issue-with-Datagrid-Refreshing-Help.html
https://www.experts-exchange.com/questions/20428768/Tree-View-Help-Please-with-Tree-View.html
SpideyMod
Community Support Moderator @Experts Exchange
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!
I am in the process of cleaning up the questions for this member as this member has failed to take care of their opened questions
Experts, please leave your recommendations within the next 3 days.
Without recommendations, I intend to come back here on 2/26/2003 and:
delete with NO refund
InvisibleMan,
You have 16 opened questions and have been asked to take care of them previously. If you wish to keep your account in good standing, please take care of these questions prior to 02/26/2003.
Failing this, your account will be reviewed by a site administrator at that point. I am posting this in ALL 16 opened questions and have submitted a cleanup request in community support.
https://www.experts-exchange.com/questions/20439569/Need-help-with-creating-a-word-template-and-some-simple-fields.html
https://www.experts-exchange.com/questions/20453889/Making-a-image-or-picture-visible-with-code-Tough-Question-need-a-smarty.html
https://www.experts-exchange.com/questions/20388128/Unable-to-Log-On-to-Provider-SQLOLEDB-1.html
https://www.experts-exchange.com/questions/20343921/GREAT-PLAINS-DYNAMICS-HELP-Integration-Manager.html
https://www.experts-exchange.com/questions/20273575/DATABASE-SIZE-SHRINKING-AND-LOG-FILE-QUESTION.html
https://www.experts-exchange.com/questions/20480517/Crystal-Reports-Sum-Question-on-Amount-Field-Help-Please.html
https://www.experts-exchange.com/questions/20475331/Inputting-Text-into-a-Bound-Dropdown-Control-Help.html
https://www.experts-exchange.com/questions/20409250/Opening-Excel-File-modifying-column-width-then-saving-it-in-VB.html
https://www.experts-exchange.com/questions/20336887/Visual-Basic-Grid-Help-Different-fields-from-different-sources.html
https://www.experts-exchange.com/questions/20327829/How-to-know-what-the-latest-DLL-is-registered-on-server.html
https://www.experts-exchange.com/questions/20324132/Class-Modules-and-VB-Application-Question.html
https://www.experts-exchange.com/questions/20390261/Creating-a-HTML-Email-Feedback-Form-Can-it-be-done.html
https://www.experts-exchange.com/questions/20403544/PDF-Files-previously-on-the-Web-allowed-data-entry-now-it-does-not-Help.html
https://www.experts-exchange.com/questions/20519637/Tab-Pages-Not-Ordering-Right-on-Tab-Page-Driving-me-nuts-Help.html
https://www.experts-exchange.com/questions/20457825/Strange-Issue-with-Datagrid-Refreshing-Help.html
https://www.experts-exchange.com/questions/20428768/Tree-View-Help-Please-with-Tree-View.html
SpideyMod
Community Support Moderator @Experts Exchange
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!