Results 1 to 3 of 3
  1. #1
    rebeldolphin69 is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Jun 2016
    Posts
    1

    Multi-field search form

    I have a simple database with just ID numbers, first names, and last names and I have created a multi-field search form to look for the exact data that I want. I have created a form with text boxes for each of those fields and I have created a query that works fine whenever I run it with the information I have typed into the textboxes to get back my results. The only problem is that every time I run the query I have to hit the refresh button to get it to show the results. I am hoping that their is a way to have it automatically refresh every time I run the query.

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,525
    yes, you must reOpen, refresh the query everytime you alter the parameters.
    it wont know you changed it.

  3. #3
    trevor40's Avatar
    trevor40 is offline Advanced db Manager
    Windows XP Access 2003
    Join Date
    Feb 2014
    Location
    Australia
    Posts
    402
    you may be able to use the afterupdate action of each text box to requery the data as it's being typed

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

Similar Threads

  1. Multi-Field Search Using a Combo Box
    By amkp711 in forum Programming
    Replies: 5
    Last Post: 03-03-2015, 10:07 AM
  2. Replies: 12
    Last Post: 08-17-2013, 11:49 PM
  3. Multi field search forms
    By Rogue in forum Forms
    Replies: 10
    Last Post: 05-14-2013, 09:40 AM
  4. Multi-field Search
    By bubba61 in forum Queries
    Replies: 20
    Last Post: 04-16-2013, 10:21 AM
  5. Multi Field Combo search Form
    By Andyjones in forum Access
    Replies: 3
    Last Post: 03-12-2012, 02:13 PM

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