Problem deleting records from a table
I have two tables, tblMain and tblWorked. I want to delete records from tblMain where tblMain.loan_number = tblWorked.loan_number. When I start a new query by selecting new query, design view. I brought up the tblMain and tblWorked then joined the two tables by loan_number. In the first column, Field has tblMain.*, Table has tblMain, Delete has From. The second column, Field has loan_number, Table has tblMain, Delete has Where, Criteria has tblWorked.loan_number. When I select the view button, I see the records I want to delete. But when I run the query, it states "Cannot delete from specified tables. I've also tried to use the following SQL statement:
where tblMain.loan_number = tblWorked.loan_number
This returns a box asking me to enter the parameter value. What am I doing wrong???