<div>
SMH. Apparently someone introduced a sub that emptied the controls on load.<br />
Wonder who could have done that?<br />
Thank you!
</div>


<div>
<div class="content wysiwyg-content">
I must be tired.<br />
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. &nbsp;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. <br />
<br />
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.<br />
I KNOW THIS IS POSSIBLE. Worse, I know it is simple, but my sleep addled brain can't figure it out.
</div>
</div>


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.

SMH. Apparently someone introduced a sub that emptied the controls on load.
Wonder who could have done that?
Thank you!

Access 2013 Combobox data

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&amp;#39;t figure it out.

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.