Results 1 to 5 of 5
  1. #1
    B30 is offline Novice
    Windows Vista Access 2007
    Join Date
    Sep 2014
    Posts
    21

    Display filter criteria on report header

    I have a report that filters data based on the date range that the use selects from a form. I would like the date range that the user selects to be printed on the header of the report. I assume that I would use a text box on the report, but what do I put in the control source? I tried referencing the date field from the query, but that did not work.

  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,518
    To reference the form, as simple as:

    =Forms!FormName.TextboxName

    or things like

    ="From " & Forms!FormName.FromTextboxName & " to " & Forms!FormName.ToTextboxName
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    B30 is offline Novice
    Windows Vista Access 2007
    Join Date
    Sep 2014
    Posts
    21
    thanks! that was more simple than i expected.

  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,518
    Happy to help!
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  5. #5
    aminkhalil is offline Novice
    Windows 7 64bit Access 2013
    Join Date
    Oct 2014
    Posts
    1
    Hello guys,
    I just found this thread.
    The code given by pbaldy is closed to what I need.
    But if filtering a value, it will display the current data value on the form.
    As my form, I filter a value by Between.
    How to display on report that I filter between. For Example ' Between 0.2 to 0.5'
    You can refer my problem here for more detail.

    Any helps is highly appreciated.
    Thanks in advanced.

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

Similar Threads

  1. Replies: 7
    Last Post: 09-27-2014, 09:11 PM
  2. Replies: 6
    Last Post: 05-15-2013, 03:36 PM
  3. Replies: 1
    Last Post: 02-28-2012, 05:05 PM
  4. Replies: 32
    Last Post: 06-20-2011, 07:30 PM
  5. Replies: 3
    Last Post: 04-07-2010, 11:25 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