Access 2013 Combobox data
Posted on 2016-07-19
I must be tired.
I have a form with a bound combobox that returns a name and id, with bound column. The box displays the name and stores the id of the name in the bound table. When the form is opened on a particular record, one wants the combobox to display the record stored in its bound field. Nothing I can do will convince it to act this way. It invariably overwrites the bound data in the table and displays the combobox empty.
I have tried unbinding the combobox and saving the data on a hidden text box on the form, then setting the value of the textbox to the combobox on load, but this also does not work.
I KNOW THIS IS POSSIBLE. Worse, I know it is simple, but my sleep addled brain can't figure it out.