Results 1 to 6 of 6
  1. #1
    Gigantor is offline Novice
    Windows 8 Access 2013
    Join Date
    Aug 2015
    Posts
    3

    Have Parameter Query Show Results in a Form/Report

    Hello,



    I am working on creating a form that when you enter the parameter in a text box it will return values matching the value in the text box. Right now the query I have made only returns the values to a Table and I was curious how to make it show the matching data in a form or report so that it looks more user friendly.

    Thank you

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,521
    You can make that query the source of a form or report.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    Gigantor is offline Novice
    Windows 8 Access 2013
    Join Date
    Aug 2015
    Posts
    3
    How do I do that?

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,521
    A form or report has a record source property; set that to the query. Or use the wizard and it will ask you.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  5. #5
    Gigantor is offline Novice
    Windows 8 Access 2013
    Join Date
    Aug 2015
    Posts
    3
    Thank you!

  6. #6
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,521
    Happy to help, and welcome to the site!
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. Replies: 3
    Last Post: 06-11-2015, 01:21 PM
  2. Replies: 3
    Last Post: 07-20-2014, 08:56 PM
  3. Replies: 3
    Last Post: 01-15-2013, 01:58 PM
  4. Replies: 6
    Last Post: 05-14-2012, 07:24 AM
  5. Query Show Results on Form
    By john226 in forum Queries
    Replies: 3
    Last Post: 05-09-2011, 11:38 AM

Tags for this Thread

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