Good Morning,
I created a command button and trying to write an on click command. I created a macro to open a form. I want to open this form and to filter all records where the fields are =. In the where condition i used expression builder and put [CUST NAME]=[Rental Form]![customer]. I tried it several ways to no avail. Cust Name is in the main form and customer is in the form I'm trying to open and filter. What am I doing wrong?
I created a command button and trying to write an on click command. I created a macro to open a form. I want to open this form and to filter all records where the fields are =. In the where condition i used expression builder and put [CUST NAME]=[Rental Form]![customer]. I tried it several ways to no avail. Cust Name is in the main form and customer is in the form I'm trying to open and filter. What am I doing wrong?