Results 1 to 3 of 3

Thread: search box help

  1. #1
    Join Date
    Aug 2004

    Unhappy Unanswered: search box help

    I'm currently using a combo box within a form to make a search on a record. I can either type in the first name or use the arrow to show me all the record that I have.

    The database has become too large and I find the combo box a little clumsy. What I'm after is a box where I can type in the first name and if need be a last name too and then click on a button to make the search.

    I'm getting the info from a query and the fields names are FirstName and LastName from a table called tbl_Volunteers.

    Any help would be appreciated. I'm ok on Access, but have limited knowledge on the scripting side.

  2. #2
    Join Date
    Aug 2004

    Other options

    Does anybody have any other ideas on producing a good search box???

  3. #3
    Join Date
    Jan 2004
    Toronto, Canada
    if you want to go that route of using FirstName, lastName search boxes, use Like statements, so

    SELECT Firstname FROM Table WHERE Firstname Like "*" & Form.FirstNameField & "*";

Posting Permissions

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