Results 1 to 2 of 2
  1. #1
    N7925Y is offline Advanced Beginner
    Windows 10 Access 2013 32bit
    Join Date
    Apr 2016
    Posts
    32

    issue with parameter search window in form


    I have a form that runs a parameter query search. I also have a navigation form that I have put this search form in. When I open the navigation form, a parameter query search window pops up and i have to enter through each of the search fields before the form actually opens. Any ideas on how to disable these windows from opening?

  2. #2
    Perceptus's Avatar
    Perceptus is offline Expert
    Windows 7 64bit Access 2007
    Join Date
    Nov 2012
    Location
    Knoxville, Tennessee
    Posts
    659
    You could run the parameter query from VBA. and then bind the form with the resulting query.

    Like below if you had an action query called qryQueryNamesAreAmazing that needed a parameter called "ParameterA".
    Set db = CurrentDb
    Set qdf = db.QueryDefs("qryQueryNamesAreAmazing")
    qdf!ParameterA = "Parameter Text is so cool"
    qdf.execute
    Set qdf = Nothing
    Set db = Nothing

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

Similar Threads

  1. Replies: 5
    Last Post: 10-29-2017, 06:46 AM
  2. Replies: 2
    Last Post: 03-12-2014, 04:30 AM
  3. Replies: 5
    Last Post: 02-10-2014, 04:46 PM
  4. Replies: 1
    Last Post: 06-19-2013, 12:32 AM
  5. Form/Combo box parameter issue.
    By Bmo in forum Forms
    Replies: 2
    Last Post: 05-06-2010, 03:41 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