Results 1 to 3 of 3
  1. #1
    deejay21 is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jan 2018
    Posts
    2

    Form Update or refresh from select Query

    I have a query that uses: Like "*" & [Enter Client name:] & "*" in criteria, useful for selecting a client or group of clients. If, in the query, I want to search multiple times I just click the "Refresh All" button on the ribbon. I have then created a dialog format form using this query for my underlying data, when I open the form I get the expected search dialog box, but if I want to do multiple searches I have to close the form and reopen. Is there a way that mimics the refresh all button that's in the ribbon (which has been greyed out when the form is open, my choice) by putting a "Search Again" button on the form, either using a macro or code? Any help would be appreciated.

  2. #2
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,412
    you could try putting the code

    me.requery

    as the code behind a button click event.

  3. #3
    deejay21 is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jan 2018
    Posts
    2
    Thanks, the issue I had has been sorted, via a different method.

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

Similar Threads

  1. Query Update/Select Query (Wont Update)
    By NickWren in forum Access
    Replies: 1
    Last Post: 03-30-2016, 10:41 AM
  2. need VBA to refresh a query after combobox select
    By accessmatt in forum Programming
    Replies: 2
    Last Post: 11-18-2014, 08:24 AM
  3. ADO Update fails after Form Refresh
    By EddieN1 in forum Programming
    Replies: 4
    Last Post: 12-19-2011, 08:07 PM
  4. update/refresh form
    By SlowPoke in forum Access
    Replies: 3
    Last Post: 09-20-2010, 09:21 AM
  5. Update/ Refresh Query
    By Vikki in forum Queries
    Replies: 0
    Last Post: 03-23-2010, 06:59 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