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

    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
    Location
    Cary, NC
    Posts
    264
    Seems that you and Reabernathy are working on the same problem!http://www.dbforums.com/microsoft-ac....html#poststop

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

    Steve

Posting Permissions

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