Results 1 to 2 of 2

Thread: Bookmarks

  1. #1
    Join Date
    Mar 2003
    Posts
    2

    Question Unanswered: Bookmarks

    Hello all.

    I am having a problem with a db i did not create. My situation is this: I have a combobox afterupdate method to find a selected record. What i want is to mark a checkbox if found and leave blank if not found. I used the .value=-1 after me.bookmark = me.recordsetclone.bookmark and it works for a matching record. However, if a match does not exist and i tab out of the field to search via another combobox i get a runtime error as it tries to update the field of a blank record for which i have not created. How can i get around this?


    Thanks in advance.

    Code:

    Me.RecordsetClone.FindFirst "[Barcode] = '" & Me![FindBarcode] & "'"
    Me.Bookmark = Me.RecordsetClone.Bookmark
    Site_needs.Value = -1


    If FindBarcode <> Me.RecordsetClone("barcode") Then
    If Barcode <> Me.RecordsetClone("barcode") Or Barcode <> FindBarcode Then

    MsgBox "No records found matching the search criteria."

    bBarcodeMove = False

    Else
    bBarcodeMove = True
    End If
    Else
    bBarcodeMove = True
    End If

    End Sub

  2. #2
    Join Date
    Mar 2003
    Posts
    2

    Re: Bookmarks

    DUH!!!!!!!

    Nevermind.

    Thanks.

Posting Permissions

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