Results 1 to 5 of 5

Thread: Search Function

  1. #1
    Join Date
    Feb 2004
    Location
    Alpine Califormia
    Posts
    1,789

    Unanswered: Search Function

    Hi all

    I have an ADP that I created a function on that when users look up a last name they get a query of records with that last name. What I would liek to happen is for those results to end up on the Form rather then the query. Is this possible and how would I go about doing it??


    Thank you
    Last edited by desireemm; 04-15-09 at 17:23.

  2. #2
    Join Date
    Jun 2004
    Location
    Seattle, WA
    Posts
    601
    You can make a query that prompts for a parameter, then make a form from that query.
    Ryan
    My Blog

  3. #3
    Join Date
    Feb 2004
    Location
    Alpine Califormia
    Posts
    1,789

    Hmm Ok

    Can you give me an example please??

  4. #4
    Join Date
    Jun 2004
    Location
    Seattle, WA
    Posts
    601
    In your query, type [Search for a last name] in the criteria box under the field you want, this will make you be able to search/filter a query.

    The important part is that you put something in square brackets in the criteria spot under the field you want to base your search on.
    Ryan
    My Blog

  5. #5
    Join Date
    Feb 2004
    Location
    Alpine Califormia
    Posts
    1,789

    Adp

    Cant quite do it with the [enter lastname] because its an ADP not an MDB. I had to make it into a Function or stored procedure and

    Code:
     =@Enter_LASTNAME

Posting Permissions

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