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?