Kamis, 16 November 2023

[MSAccessProfessionals] Strange Combo Box Behavior

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

Tidak ada komentar:

Posting Komentar