Microsoft Access Combo Box Bug

Question

Microsoft Access Version: Version 2205 Build 16.0.15225.20028) 32-bit

I have forms with combo boxes that are populated from table information. They are formatted in the typical 2 column format with the first bound column being hidden. The value in the combo box is the control source for a field in the underlying record set that is part of a split database (front end/back end). The issue is as follows:

The form is working just fine. It has been working for others as well. Out of nowhere, the form will not let the user select anything. It will expand and show the options but nothing can be selected. If the combo box value is changed by VBA code, a box will pop up telling the user that they cannot change the data. What I have found is that if I change the form to design mode and then toggle practically ANY option, such as "Limit To Lits" or "Show only row source" or "Bound Column", the combo box will begin working again. In other words, the user can select values and the VBA code can change the value of it again. Note: I just toggle these settings from YES to NO to YES again or vice versa. So, this is definitely a bug.

There is also the possibility that this bug appears only AFTER I have gone into "Design" mode, but it doesn't happen every time so I haven't been able to verify this. I have started checking all my forms that use a combo box this way before uploading them for others to use. If it throws the fault then I select the combo box involved and toggle any setting to fix it before uploading the form for further use.

Is anyone else running into this?

Answer 1

Can you reproduce this with the Northwind sample application (File > New)? For example the Order form has a Customer dropdown and a Salesperson dropdown. They still work just fine for me.

BTW, I don't recommend Current Channel for business use of Office. Too buggy. Semi-Annual Enterprise is much more stable.