Results 1 to 8 of 8

Unbound form for data filtering

  1. #1
    alliandrina is offline Novice
    Windows XP Access 2007
    Join Date
    Feb 2011
    Posts
    12

    Unbound form for data filtering


    In reading some of the posts, I have learned that using an unbound form with start and end dates is how to filter a report and its subreport. I have built the form. I also added a drop box so I can choose the report I need. I'm just not sure how to get it to work... I know this may seem simple many others, but I am self taught... so if anyone can help out I would appreciate. Thanks!

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    20,792
    Two typical options are using a criteria in the query the report is based on or using this type of thing:

    BaldyWeb wherecondition

    If the subreport also needs the criteria, the query criteria would be the way to go. It would look like:

    Between Forms!FormName.StartDateTextbox And Forms!FormName.EndDateTextbox
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    alliandrina is offline Novice
    Windows XP Access 2007
    Join Date
    Feb 2011
    Posts
    12

    Thanks for the Reply

    I have seen that suggestion before, but I'm not quite sure where to put it.

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    20,792
    Which one? The "Between..." bit would be the query criteria.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  5. #5
    alliandrina is offline Novice
    Windows XP Access 2007
    Join Date
    Feb 2011
    Posts
    12
    I think it would be the second. Like I said all I have it the form built. From what you say, I guess I would need to make a query and put that code in the criteria line? What do I base the query on?

  6. #6
    alansidman's Avatar
    alansidman is offline Life @ 7100'
    Windows 7 32bit Access 2007
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,441
    Is this what you are trying to do?

    http://www.datapigtechnologies.com/f...earchform.html

    Alan

  7. #7
    alliandrina is offline Novice
    Windows XP Access 2007
    Join Date
    Feb 2011
    Posts
    12

    I don't think so...

    I have a few reports with a few subreports. I want to be able to select a report and filter that plus the subs by data when it opens. I've read around and seen some of the answers that other people got, but I don't know enough to apply them.

  8. #8
    alliandrina is offline Novice
    Windows XP Access 2007
    Join Date
    Feb 2011
    Posts
    12
    I finally figured out how to get the unbound form with the start and end date text boxes to work. I took the code "Between Forms!FormName.StartDateTextbox And Forms!FormName.EndDateTextbox " modded it a bit and then put it to the 'filter' section of the subreports property sheet. Just in case anyone else see this and a similar prob I had an unbound report that I was populating with subs.

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

Similar Threads

  1. Replies: 1
    Last Post: 01-23-2011, 09:21 AM
  2. Filtering/sorting data
    By jemelton in forum Access
    Replies: 5
    Last Post: 06-09-2010, 01:47 PM
  3. Replies: 0
    Last Post: 05-09-2010, 08:43 AM
  4. Input data In unbound text box
    By chu3w in forum Forms
    Replies: 1
    Last Post: 04-01-2010, 10:21 AM
  5. Filtering data
    By billybong in forum Access
    Replies: 1
    Last Post: 11-07-2009, 12:20 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
  •  
Tech Forums: Microsoft Office Forums