Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    Jul 2001
    Location
    NJ, USA
    Posts
    617
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Credit form in front of a report (Access 2002, Win 98 2nd R)

    I was wondering how to put a form in front of a report so that people with no experience has an easier time of using the program.

    The other question regards a report with two subreports. both sub forms have 3 parameters each. The parameters are the same on both subreports. How can I fix it so that I have to input the data only once?

    Thank you for your time and responses. Fay

  2. #2
    Star Lounger
    Join Date
    Nov 2001
    Location
    Illinois, USA
    Posts
    60
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Credit form in front of a report (Access 2002, Win 98 2nd R)

    You can create a criteria form that will have fields for all the parameters needed. So let's say you need a start date and end date; put those two textboxes on a form frmDateCriteria; add an "OK" button, cmdOK; in cmdOK click event make the form invisible. In the open event of your report, add code to open frmDateCriteria. When users fill in the parameters and click OK, the report will run. In the close event of the report, close the criteria form. You will also want to change the queries behind your subreports to pull values from the form, so instead of [Enter Start Date] in the criteria, use Forms!frmDateCriteria!txtStartDate.

  3. #3
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Credit form in front of a report (Access 2002, Win 98 2nd R)

    If the subreports are properly linked to the report, you shouldn't need parameters on them because their recordsets will be filtered by the parent report. If you're using unbound subreports, that is subreports not linked to the parent report, then you'll have to do it as Dottie suggests.

    Credit form? What exactly do you mean by that? Are you talking about a switchboard/menu form?
    Charlotte

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •