Query Locking out Changes

[davidmo]

I have created a query (qry_process_steps) that is based on a table (tbl_loan_information) and a query (qryOriginatorsEmail)

Before I brought the qryOriginatorsEmail into qry_process_steps I was able to make changes to the fields generated by original query. Once I brought the qryOriginatorsEmail into the query it has locked out changes to the fields. Not sure why. Below is the SQL the query is based on.

SELECT tbl_Loan_Information.Lender_Case_Number, tbl_Loan_Information.Borrower_Social_Security_Number, tbl_Loan_Information.Borrower_Two_Year_Tax_Return, tbl_Loan_Information.Borrower_Two_Year_Tax_Return_Link, tbl_Loan_Information.Borrower_Paystubs, tbl_Loan_Information.Borrower_Paystubs_Link, tbl_Loan_Information.Borrower_Three_Month_Bank_Statement, tbl_Loan_Information.Borrower_Three_Month_Bank_Statement_Link, tbl_Loan_Information.Subject_Appraisal_Complete, tbl_Loan_Information.Subject_Appraisal_Complete_Link, tbl_Loan_Information.Subject_Escrow_Title, tbl_Loan_Information.Subject_Flood_Certificate_Need, tbl_Loan_Information.Subject_Flood_Certificate_Documentation, tbl_Loan_Information.Subject_Insurance_Coverage, tbl_Loan_Information.Subject_Insurance_Coverage_Link, qryOriginatorsEmail.[Full Name], qryOriginatorsEmail.Originator_Email_Address
FROM tbl_Loan_Information INNER JOIN qryOriginatorsEmail ON tbl_Loan_Information.Borrower_Social_Security_Number = qryOriginatorsEmail.Borrower_Social_Security_Number;

If anyone has an idea, would much appreciate it.

thanks.

DMo

 

[PHV]

Have a look here:

http://msdn.microsoft.com/archive/en-us/dnaraccess/html/msdn_harness.asp

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886