Recent content by Chantal

  1. C

    Filter reports based on 2 multiselect listboxes

    Yup that's right... The months from January to December, and the years from 2010 to 2012
  2. C

    Filter reports based on 2 multiselect listboxes

    Yup... it just asks me to enter the parameter values
  3. C

    Filter reports based on 2 multiselect listboxes

    ok I'll try
  4. C

    Filter reports based on 2 multiselect listboxes

    James, I forgot to mention that the query works fine when i reference it as following: Like "*" & [Forms]![Reports Dialog]![lstYear] Like "*" & [Forms]![Reports Dialog]![lstMonth] But i don't get the needed information when I choose to generate the report from the Report Dialog form. So I...
  5. C

    Filter reports based on 2 multiselect listboxes

    Yup the query came up blank... The Lists are actually value listboxes and not comboboxes, I'm not sure if that's the problem. I guess we need to write the codes instead of refrencing the query, just as I did with the first listbox through which users can choose the report they need...
  6. C

    Filter reports based on 2 multiselect listboxes

    Thanks James... Yeah, it's based on a query. I tried the references before and it resulted in a no data error. I even tried to add the Like "*" at the beginning of the references which resulted in including all the data in the reports, not just only the ones I selected. It's ok if it ended up...
  7. C

    Filter reports based on 2 multiselect listboxes

    Hello, I need help with the following code which is working perfectly. However, I'm unable to add the Where clause which will enable the users to filter reports by year and/or by month. These 2 criterias are listed in 2 unbound multiselect value listboxes (lstYear and lstMonth) and should be...
See more
Back
Top Bottom