christrawick
Programmer
I've got a VB form with an ADODB connection to an Access table. Each of the text fields are bound to the respective Access table fields. There is a combobox on the VB form that is being populated by an existing Access query. It works great, but here's my dilemna:
For records already in the database with a value already chosen for the "combobox" field, if I populate the combo during the FormLoad procedure, the value is cleared, and the user must re-select it from the combo drop down. While this works great for adding new records in which I want the user to select a value from the drop down, how do I configure it so that the pre-existing selection will display within the combo? If the user wants to change the value for a certain record, that's fine, but the value needs to be preserved initially on opening each individual record.
Thanks alot
For records already in the database with a value already chosen for the "combobox" field, if I populate the combo during the FormLoad procedure, the value is cleared, and the user must re-select it from the combo drop down. While this works great for adding new records in which I want the user to select a value from the drop down, how do I configure it so that the pre-existing selection will display within the combo? If the user wants to change the value for a certain record, that's fine, but the value needs to be preserved initially on opening each individual record.
Thanks alot