Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2015

    Unanswered: Creating a query or report with selectable parameters


    I want to create a query and/or report in Access 2013 that allows the user to select parameters for the display of data.

    For example, I want to create a report for maintenance costs that allows the user to select the name of
    a property. Based on this selection a report will be created that itemises all the costs for maintenance
    and totals them.

    I have got the basic report working the way I want it. I just need to know the code for selecting property
    name or frgnPropertyID if that is easier.

    The other fields in the form, called frmMaintenance, are Cost, Comments, and MaintenanceID.

  2. #2
    Join Date
    Nov 2004
    out on a limb
    Provided Answers: 59
    you can open a report (or form for that matter) specifying parameters

    use the docmd.openreport method
    and specify the parameters as a string inthe openargs parameter of openreport (the 6th parameter)

    Use a form to define the parameters,
    then use a command button to build the openargs parameter iteself, and then open the report
    I'd rather be riding on the Tiger 800 or the Norton

Tags for this Thread

Posting Permissions

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