Results 1 to 2 of 2
  1. #1
    Join Date
    May 2012
    Posts
    1

    Unanswered: Search Form Help

    Hello Everyone,

    I am brand new to Access.

    I am trying to create a search form that you can search multiple fields on. When I click "Search" I would like it to search the table according to the parameters I inputted on the form.

    I would then like the results of the search to show up on the same or similar looking form.

    Is that possible?

    I have it now that I can input in multiple fields and use a query to search the table. The problem is that it goes to the row by row query view (which doesn't work for my situation).

    I really appreciate your help!

  2. #2
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    Here's a link to a hack Allen Browne developed for doing this very thing:

    Microsoft Access tips: Search criteria

    Linq ;0)>
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

Posting Permissions

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