Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2005
    Posts
    144

    Unhappy Unanswered: Clear Combobox search

    Hello all,
    Is it possible to get rid of the last search done by combobox??

    What i meant by that is i have my cbo setup as search and i am using this code on my after update event.

    Private Sub Combo89_AfterUpdate()
    ' Find the record that matches the control.
    Me.RecordsetClone.FindFirst "[ID] = " & Me![Combo89]
    Me.Bookmark = Me.RecordsetClone.Bookmark
    End Sub

    After it takes me to the desire result at that point i would like to clear the search from the combobox, because if i were to hit delete and click next record on the navigation panel i get an error
    "syntax error (missng operator) in expression"

    and it highlights this line
    Me.RecordsetClone.FindFirst "[ID] = " & Me![Combo89]

    Any suggestions??
    i hope i was clear enough?
    Thanks again

  2. #2
    Join Date
    Jul 2005
    Posts
    144
    Anybody wants to take a shot at it??

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •