Expr1 Name Issue when using Filter

[Pada]

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.

[Welshgasman]

Unsure why you need to trim in one instance, but not another?

You can rename Expr1 to anything you want other than the name of the field it is trimming.

So just filter as normal except you will be using

Expr1 = Series where Series is whatever is passed back from Form2.

[Pada]

Thanks Welshgasman. I can't change Expr1 to Series. If I do that, it pops up an error message saying "circular reference" meaning it doesn't accept the same name as the field Series.

[Pada]

I have actually just tested by added something into the code of form2. When a user clicks on the combo box drop down and select a series and click the OK button, the code behind that event click button will check and assign Series = cboSeries.value. Now I change it from Series to Expr1 = cboSeries.value and it appears working. Question is do you think this is the right way to fix the parameter popping up? Thank you.
I like to add. Even Expr1 is not declared in the form2 code, it looks like VBA still accept it. Is this a red flag for potential issue later?

[Welshgasman]

Thanks Welshgasman. I can't change Expr1 to Series. If I do that, it pops up an error message saying "circular reference" meaning it doesn't accept the same name as the field Series.

That is what I said?

[Welshgasman]

I would give it a more meaninful name?, TrimSeries perhaps?

[Micron]

Why not just pick the filter value from the same main form and then apply it?

[Pada]

Yes, a more meaningful name is better, but it's still different with than the Series and it still pops up the dialog box asking for parameter Series

[Pada]

I am inherited this program and it is designed that way. Also, the form2 is for showing a list of several fields available to users to use whatever field they want to.