Professional Web Applications Themes

How to link 3 different combo boxex in a form (as report criteria) to the report - Microsoft Access

I would like to use 3 combo boxes in a form as parameter criteria for a report. When I open a report, there will be a pop up form with 3 combo boxes. I am already able to link the report to the form. However after the user select the content of all 3 combo boxes and then click the preview report command button, I would like to be able to open the report based on the selected option from the 3 combo boxes. Currently after clicking the preview command button in the form with combo box, the report can ...

  1. #1

    Default How to link 3 different combo boxex in a form (as report criteria) to the report

    I would like to use 3 combo boxes in a form as parameter
    criteria for a report.
    When I open a report, there will be a pop up form with 3
    combo boxes. I am already able to link the report to the
    form. However after the user select the content of all 3
    combo boxes and then click the preview report command
    button, I would like to be able to open the report based
    on the selected option from the 3 combo boxes. Currently
    after clicking the preview command button in the form with
    combo box, the report can be opened but it shows all the
    data, not the specific data based on the criteria selected
    from the combo box in the form.
    Thus, how to link 3 different combo boxex in a form (as
    report criteria) to the report?
    Can anyone help me with this please? I will really
    appreciate your response in this.

    Thanks,
    Hart
    Hart Guest

  2. #2

    Default Re: How to link 3 different combo boxex in a form (as report criteria) to the report

    ps. To refer to a value on the form, the form must be open. I assume you are opening the
    form from the report with the "acDialog" window mode argument since this will halt the
    code and the opening of the report until you are done with the form. The code will
    continue when the form is closed or hidden, in this case you need hidden (Visible=No)
    because the form has to be open to read the combo boxes.

    --
    Wayne Morgan
    Microsoft Access MVP


    Wayne Morgan Guest

Similar Threads

  1. Replies: 3
    Last Post: May 9th, 01:55 PM
  2. preflight XML report differs from droplet report
    By Robert_Zegwaard@adobeforums.com in forum Adobe Acrobat Macintosh
    Replies: 0
    Last Post: April 7th, 07:57 PM
  3. use form to enter report criteria
    By Mary in forum Microsoft Access
    Replies: 2
    Last Post: July 30th, 04:08 PM
  4. Form --> report problem
    By Jill in forum Microsoft Access
    Replies: 1
    Last Post: July 3rd, 08:27 AM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139