recordset not updatable

[SaraMegan]

I have made a form from a query. The query has no calculations in it or anything, but still the recordset is not updatable.

I've tried using different types of joins for this, but the query doesn't work with outer joins.

Here's my SQL. I'm probably missing something pretty basic, but I'm not sure what it is.

SELECT tblApplication.ApplicationID, tblApplicants.LastName, tblApplicants.FrstName, tblApplicants.SSN, tblApplication.SourceID, tblApplication.Recvd, tblApplication.Certified, tblApplication.LetterSent, tblApplication.TestDate, tblApplication.TestScore, tblApplication.SentToSupervisor, tblApplication.JobOffered, tblApplication.Hired, tblApplication.Comments, tblApplication.ApplicationStatus
FROM tblApplicants INNER JOIN tblApplication ON (tblApplicants.SSN = tblApplication.SSN) AND (tblApplicants.SSN = tblApplication.SSN);

Please let me know if I need to clarify further.

Thanks

--Sara

 

[SaraMegan]

duh...

Thanks, Pat. I knew it was something basic.

Works great now!

--Sara