Results 1 to 6 of 6
  1. #1
    Casper2012 is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    Aug 2011
    Posts
    18

    Parameter Query....

    Hi-

    Is there a way to run a parameter query and have the results open into a form?



  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,931
    Make the query the RecordSource for the form.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    Casper2012 is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    Aug 2011
    Posts
    18
    I am currently running a query for that form in the RecordSource. I there a way to run 2?

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,931
    Is this the same issue in your thread https://www.accessforums.net/forms/c...uck-16184.html ?

    A form or report can have only one RecordSource. You can have a subform or subreport for the other query or even a listbox. Would have to know more about your data to better advise.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    Casper2012 is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    Aug 2011
    Posts
    18
    Hi June-
    Yes, it is basically the same form. Like I was saying though, that db only has fictional people. The actual one I am working on has all my data criterias. I would like to posst that one but it has too much data and the file is too large. But basically the same principle.

  6. #6
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,931
    Data is not important, structure is. I will make further responses only to the other thread.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. How to run parameter query from VBA
    By John Southern in forum Programming
    Replies: 10
    Last Post: 02-07-2014, 02:24 PM
  2. Parameter Query?
    By luckysarea in forum Queries
    Replies: 3
    Last Post: 04-22-2011, 12:57 PM
  3. Parameter query
    By doss13 in forum Queries
    Replies: 1
    Last Post: 06-26-2010, 06:11 AM
  4. Parameter Query help...
    By daggy in forum Queries
    Replies: 1
    Last Post: 05-11-2010, 01:10 AM
  5. Get value typed in for a Parameter query
    By terryvanduzee in forum Forms
    Replies: 1
    Last Post: 10-14-2009, 03: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