I have a form, form1 with a record source say query1. In the query1, I added a Trim function for a field named Series, so the Expr1 showing up for that field name. On form1 has a button Filter when clicked will open another form, form2. On form2 there is a combo box allow use to select a specific series and this series will be passed back to form1 that filter data to display all records that matches the selected Series only.
The problem is now in the query1, the field Series is now Expr1 and therefore it is no longer match with the Series passed from form2. A dialog pops up asking for a Series parameter.
Do you know how to fix this issue without taking out the Trim function. Thank you very much in advance. It is an urgent issue.