Still trying to understand...
The first problem I found is a circular reference in the query for the list box "ErrorCodeDescription" See the RED text below. The alias must not be the same as another access object.
Code:
ErrorCodeDescription: row source is SELECT [Error_Codes_and_Corrections]![Error Codes and Corrections] & "-" & [Error_Codes_and_Corrections]![Error Code Description] AS [Error Code Description]
FROM Error_Codes_and_Corrections
ORDER BY [Error_Codes_and_Corrections]![Error Codes and Corrections] & "-" & [Error_Codes_and_Corrections]![Error Code Description];
Both list boxes are based on the same table??
Problem 2 -
Code:
On Error GoTo Err_Handler
there is not an error handler in the code
The result of your code for strWhere is "[ErrorCodeDescription] IN (1008-Invalid account number,1015-Invalid date)"
In the query for the report, is there a field named "[ErrorCodeDescription]" that has data like "1008-Invalid account number"???
By chance do you have a field in a table defined as a "List box"??? (I hope not) I'm asking because you said "I have two fields called ErrorCodeDescription and ErrorCodeCorrections. I created an access form with the two fields. I changed the types to listbox". Maybe it is just termonology.....Forms have controls, tables have fields.