Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2012

    Unanswered: Multiselect and Open report based on selection

    I have an access form called frm_MyForm. It has two multiselect listbox fields called
    ErrorCode and ErrorCorrection. I chose Multiselect = extended. In the form, the user can select multiple ErrorCodes or ErrorCorrections. I want to do the following:
    When the user highlights and selects the multiple values in both fields, I want to be able to filter them and open an access report based on the chosen values. I then want to clear the filter and start again. Can this be done in either a macro or vba?

  2. #2
    Join Date
    Aug 2004
    Cary, NC
    Seems that you and Reabernathy are working on the same problem!

    so yes, this can be done in vba. Get as far alone as you can and ask a specific question when you get stuck.


Posting Permissions

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