Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2019
    Posts
    1

    Angry Search a query

    This seems ridiculously easy but after a week searching youtube, Im over it...

    Have a table, Have a query, have a form have buttons and macro.



    I want to type my search criteria into a text box and search that record and have it displayed in the form. Im sure its only the addressing im getting wrong but FFS...

  2. #2
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    Allen Browne has several search forms you could consider - but using VBA not macros
    http://allenbrowne.com/ser-62.html , http://allenbrowne.com/AppFindAsUType.html, http://allenbrowne.com/AppSearchHighlight.html
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  3. #3
    orange's Avatar
    orange is online now Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    A week?
    In addition to Colin's specific examples, you could try Google with this as criteria ms access search form example.
    Welcome to the forum.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 3
    Last Post: 03-16-2017, 11:22 AM
  2. Replies: 10
    Last Post: 09-08-2016, 08:09 PM
  3. Search Query
    By sgray in forum Queries
    Replies: 7
    Last Post: 02-16-2012, 04:37 AM
  4. Help with search query
    By Sirius in forum Queries
    Replies: 0
    Last Post: 08-08-2011, 03:33 PM
  5. yes/no search query
    By islandboy in forum Queries
    Replies: 7
    Last Post: 06-30-2009, 09:01 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums