Hi
I'm using the following vba to reset the record source i.e. (Me.RecordSource = strFilter)
strFilter = "SELECT * FROM tblApplication INNER JOIN tblCustomer ON tblApplication.cust_id = tblCustomer.cust_id " & _
"WHERE (tblCustomer.cust_short_name) = " & [Forms]![frmApplication]![cboCustomerSearch] & ";"
Unfortunately I get an error message;
"runtime error '2001' you cancelled the previous operation"
From other post I believe the error is in the SQL.
Any ideas anyone. Your help would be greatly appreciated
Cheers
I'm using the following vba to reset the record source i.e. (Me.RecordSource = strFilter)
strFilter = "SELECT * FROM tblApplication INNER JOIN tblCustomer ON tblApplication.cust_id = tblCustomer.cust_id " & _
"WHERE (tblCustomer.cust_short_name) = " & [Forms]![frmApplication]![cboCustomerSearch] & ";"
Unfortunately I get an error message;
"runtime error '2001' you cancelled the previous operation"
From other post I believe the error is in the SQL.
Any ideas anyone. Your help would be greatly appreciated
Cheers