Re: [MSAccessProfessionals] Strange Combo Box Behavior

Are you suggesting the combo box doesn't allow selecting values other than a or b? Or is the correct value selected in the combo box but the find doesn't work?

There is a known bug with combo boxes as noted at https://www.accessforever.org/post/combo-box-auto-expand-may-not-work-correctly-in-windows-11

Duane

---

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> on behalf of paco@cellarinfo.com <paco@cellarinfo.com>

 

II have a combo box on a form that is used to find a specific record. The behavior is that when the first letter of the record to find is entered, the combo box record list moves to that record so that hitting enter displays the selected record on the form - fairly standard cboFind. The problem is that it works as expected when an "a" or a "b" is entered. Anything above a or b doesn't produce the expected behavior. Even stranger is that I have an almost identical form where everything works fine (one looks up wine and the other looks of wineries). In fact, there are several other forms where the find works as expected. The recordset for the form that doesn't work is around 750 and is sorted alphabetically.

Any ideas?

    If Me.CurrentView = 2 Then

        Exit Sub

    End If

    Me.FilterOn = False

    DoCmd.GoToControl "txtWine"

    DoCmd.FindRecord "" & Me!cboFind & ""

    Me.sfrmWineLocation.SetFocus

    Me.cboFind = Null

Version

__._,_