I am trying to open a recordset with two criteria items. Customer_No in the recordset should match the Customer_No field on my form and the "Active" field in the recordset should be a "Y". Both fields are text.
I can't seem to get the syntax for the 'active' correct. Below is a snippet of what I am trying.
rst.FindFirst "Customer_No = '" & Me.Customer_No & "' " And "Active = '"Y"'
Where am I going wrong?