<div>
Do you have code (or a macro) in one of the control's events that is causing this?
</div>


Do you have code (or a macro) in one of the control's events that is causing this?

<div>
All I have is the code to load the combobox in the On Enter event.
</div>


All I have is the code to load the combobox in the On Enter event.

<div>
<div class="content wysiwyg-content">
Hi all.<br />
<br />
I have an Access form with a combobox whose row source is set to &quot;Table/View/StoredProc&quot; and is populated in the On Enter event. There are 2 columns with widths (0&quot;;1&quot;) the first column is the ID and the second is the name, the end user sees the name but when they save the record the ID is what gets saved in the table.<br />
<br />
The problem we're having is if the end user enters the combobox via the mouse or tab without clicking on the down arrow it temporarily changes the selected value/text of the combobox to the first entry of the combobox but then it reverts back to the original selected value/text when you leave the combobox. <br />
<br />
Any idea how we can stop this from happening?<br />
<br />
Thank you in advance.
</div>
</div>


Hi all.

I have an Access form with a combobox whose row source is set to "Table/View/StoredProc" and is populated in the On Enter event. There are 2 columns with widths (0";1") the first column is the ID and the second is the name, the end user sees the name but when they save the record the ID is what gets saved in the table.

The problem we're having is if the end user enters the combobox via the mouse or tab without clicking on the down arrow it temporarily changes the selected value/text of the combobox to the first entry of the combobox but then it reverts back to the original selected value/text when you leave the combobox. 

Any idea how we can stop this from happening?

Thank you in advance.

Combo box changes to first entry when end user clicks inside combobox Access 2003 VBA

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.