Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2004
    Posts
    29

    Exclamation Unanswered: create report based on form..

    Hi,

    How can I create a report based on the selections made in the form where I have dropdown, checkboxes fields?

    I tried creating a query based on the criteria and when I preview my report it displays the dialog window where it asks the user to enter the criteria for each field. And I have more than 10 check boxes in the form so it asks me 10 times (it displays dialog box for 10 different check boxes plus other fileds I have with the criteria on it) to enter the criteria I am looking for...

    Is there any way that instead of displaying the dialog boxes and entering the criteria , report is created just based on the selections I made in the form? Because I don't want to enter criteria more than 10 times to get the report?

    I would appreciate your help. Your help is urgently needed.

    Thanks in advance.

  2. #2
    Join Date
    Mar 2004
    Posts
    128

    Lightbulb Report bases on form

    Hi,
    After you build your query,you can build the same fields on the reports.
    In the Report_load() event, you can use the recordsource=query name.
    Access will recognize that he will take the records in the report from the query.

    you write:
    public sub Report_load()
    Me.recordsource = {Query name}
    end sub

    I hope it help you

  3. #3
    Join Date
    Mar 2004
    Posts
    128

    report

    Hi,
    After you build your query,you can build the same fields on the reports.
    In the Report_load() event, you can use the recordsource=query name.
    Access will recognize that he will take the records in the report from the query.

    you write:
    public sub Report_load()
    Me.recordsource = {Query name}
    end sub

    I hope it help you

Posting Permissions

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