Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Sep 2006
    Posts
    166
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Find First (Access 2000)

    I have a ListBox on my form and i want by double clicking on the contactid in the list box to open the contactid of the form.Both the form and the listbox are based on the table TblClients.Which is the best way to do that ? I know there are several way as FindiFisrt , Search, etc.
    I have the following available function :

    Dim f As Form
    Set f =Forms!frmClients
    f.RecordsetClone.FindFirst "ContactID = " & strContactID
    If f.RecordsetClone.NoMatch Then
    MsgBox "not available"
    f.Bookmark = strBookmark
    Else
    f.Bookmark = f.RecordsetClone.Bookmark
    End If

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Find First (Access 2000)

    You should be able to use the code you posted if you set strContactID to the value of the list box.

Posting Permissions

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