Unanswered: Using SQL back-end ACCESS proj doesn't run properly
I have a form that I pull up from another form - the second form should show all records with matching CustomerID to the first form's record I selected.... I was using a SQL Server back-end and it would not work - I use an MS Access back-end and now it works??? MS Access allows you to put in the criteria that filters out the records you do not want. Using the same criteria with the SQL back end the form showed ALL records with ANY customerID that matched in both form's tables.... I only want the records with the customerID for that ONE record from the other table (table: Projects)
Anyone have any insight on this or know how to do it with a SQL back-end?