Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2008
    Posts
    25

    Unanswered: Reporting issue: Want to select Species from list to run specific report

    Hi there,

    I would like to customize my reporting so the user can complete these steps:

    1) select a species from a drop-down list
    2) generate a report for that species

    So far I have created the following:

    1) a form (ReportSelect_Species) with a drop-down Species list (gets values from MonitorFauna table) note:drop-down called 'SpeciesIDList'
    2) a query that includes desired info
    3) in the criteria of the query I placed the following code under the SpeciesID Column:
    Code:
    Forms!MonitorFauna!cboSpeciesIDList
    4) a blank report with the recordsource set to the query
    5) the form's recordsource is set to the report

    When I open the form, the drop-down list is not working properly, I see the values but it will not allow me to select a species nor does it run the report.

    Any suggestions as to what might be wrong would be greatly appreciated!

    thanks

  2. #2
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Forms!MonitorFauna!cboSpeciesIDList
    Isn't MonitorFauna a table?

    Shouldn't that be

    Code:
    Forms!ReportSelect_Species!SpeciesIDList
    5) the form's recordsource is set to the report
    What the?
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  3. #3
    Join Date
    Aug 2008
    Posts
    25
    Yes MonitorFauna is a form, which has a recordsource pointing to a table called MonitorFauna. I realize I should have called it something like tblMonitorFauna.

    As for issue 5 (the form's recordsource is set to the report ) I cleared the recordsource.

    Any suggestions from that?

  4. #4
    Join Date
    Dec 2003
    Location
    Dallas, TX
    Posts
    1,004

    Question

    Quote Originally Posted by gbuckton
    Hi there,


    4) a blank report with the recordsource set to the query
    5) the form's recordsource is set to the report

    thanks
    gbuckton,

    I think what he is startled about is number 5. Why or how is the recordsource of the Form...set to the Report??? Not to the query or table? Are you saying you set the Report itself as the recordsource of the Form?

    Bud

Posting Permissions

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