Results 1 to 3 of 3

Thread: Searching

  1. #1
    Join Date
    May 2004

    Unanswered: Searching

    Could i have a example how to search a access form by two text boxes and one search button. SO if i ahve last name and id how owuld i write the code to seach by these two text boxes?

  2. #2
    Join Date
    Feb 2005
    You could try something like this in the Click event of your button:

    Me.Recordset.FindFirst "[First Name] = " & Chr$(34) & Me.txtFirstNameTextBox & Chr$(34) & " And [Last Name] = " & Chr$(34) & Me.txtLastNameTextBox & Chr$(34)

    (the Chr$(34) add quotation marks around the textbox values)

  3. #3
    Join Date
    Nov 2004
    out on a limb
    Provided Answers: 59
    have a look at

    which should get you close to where you want to go

Posting Permissions

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