Results 1 to 3 of 3

Thread: search box help

  1. #1
    Join Date
    Aug 2004
    Posts
    2

    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
    Posts
    2

    Other options

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

  3. #3
    Join Date
    Jan 2004
    Location
    Toronto, Canada
    Posts
    259
    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
  •