Categories

ComboBox selects record

July 14th, 2009 by Brian Mickley

Private Sub Combo20_AfterUpdate()
With Me.RecordsetClone
        .FindFirst “[CustNumber] = ” & Str(Nz(Screen.ActiveControl, 0))
        If .NoMatch Then
            MsgBox “Sorry, no such record!”
        Else
            Me.Bookmark = .Bookmark
        End If
    End With
    Me.LastName.SetFocus
End Sub

Private Sub Combo20_BeforeUpdate(Cancel As Integer)

End Sub

Private Sub Combo20_GotFocus()
Me.Combo20.Dropdown
End Sub

Private Sub Form_Open(Cancel As Integer)
    Me.Combo20.SetFocus
    Me.Combo20.Dropdown
End Sub

Share

Posted in Uncategorized | No Comments »

Leave a Comment

Please note: Comment moderation is enabled and may delay your comment. There is no need to resubmit your comment.