Results 1 to 2 of 2

Thread: Search Function

  1. #1
    Join Date
    Dec 2003
    Posts
    1

    Red face Unanswered: Search Function

    HI GUYS

    Im trying to create a search function on a form that will allow me to type in a Surname (from PersonalDetails table) and return all fields corresponding to this person and everyone else with this Surname, in a view that can be edited. The in-built search function only shows one record at a time.....and u have to scroll through them.

    BELIEVE ME ive tried the Help Files, writing SQL statements, VB Code, various text books and still can't get my desired result!!!!

    U guys are my only hope ....please help if u can!!!

    PEACE

  2. #2
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Ok... Well what do you have so far? It sounds to me like you need a form for your search criteria and the "result view" ... That form would be a continuous forms form and it can be based on a single table which would allow for your direct edit ...

Posting Permissions

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