Results 1 to 3 of 3

Thread: Combo Box

  1. #1
    Join Date
    Feb 2004
    Location
    Alpine Califormia
    Posts
    1,789

    Question Unanswered: Combo Box

    I have a combo box that is suppose to find the record on my form according to the value I input. The problem is that it doesnt always work and I dont understand why??? I keep getting an visual basic error message
    this not only happens to the user to but the db owner. its an ADP file does that matter...sql server 2000 is the engine

    This is the script
    Code:
    Private Sub Combo175_AfterUpdate()
        ' Find the record that matches the control.
        Dim rs As Object
    
        Set rs = Me.Recordset.Clone
        rs.Find "[TM#] = " & Str(Nz(Me![Combo175], 0))
        If Not rs.EOF Then Me.Bookmark = rs.Bookmark
    End Sub
    Last edited by desireemm; 01-14-05 at 19:38.

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Do you have any clue what the error message is, or does it just go "toes skyward" without any information?

    -PatP

  3. #3
    Join Date
    Feb 2004
    Location
    Alpine Califormia
    Posts
    1,789

    Error

    Says runtime error '2001' you canceled the previous operation
    Last edited by desireemm; 04-15-09 at 17:23.

Posting Permissions

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