Can't edit data in query any more!

RichS

Healthy software!
Local time
Today, 14:46
Joined
Apr 16, 2008
Messages
44
In my current project, I have an imported table of Clients that I don't want to alter. Linked in a query, I also have two other tables; One holds addresses for the names, linked by Client Reference and the other holds additional comments, both of which need to be updateable.

This was working perfectly and I designed a form around it. However, I needed to add a field to the table that holds the additional comments. Since then, the form and even the query that it's based on is no longer editable. The field is a Yes/No and has a tickbox on the form. Can anyone suggest why just adding this field may stop the query from being editable?
 
Last edited:
Hi Rabbie,

Thanks for your reply. I've used the advice on that link before and it helped before, but this time there doesn't seem to be anything wrong as far as the criteria are concerned.

As I said, it was working perfectly until I added the extra field. Since then, nothing at all is editable. If it was just that field, then I would have suspected something not set correctly for it, but it's the whole query that's been affected...
 
It would be helpful if you could post the SQL for your query.
 
Ok, here goes...

Code:
SELECT PATIENT.PAT_ID, PATIENT.TITLE, PATIENT.SURNAME, PATIENT.FORENAME1, PATIENT.FORENAME2, PATIENT.DOB, PATIENT.SEX, PATIENT.MARRIED, PATIENT.NEWNHSNO, PATIENT.REG_GP, PATIENT.USUAL_GP, NEWADD.HOUSE_NAME, NEWADD.HOUSE_NO, NEWADD.ROAD_NAME, NEWADD.LOCAL_NAME, NEWADD.TOWN_NAME, NEWADD.COUNTY_NAM, NEWADD.POSTCODE, [Patient Clinical Info].DIAGNOSIS, [Patient Clinical Info].SPECIALTY, [Patient Clinical Info].LASTSEEN, [Patient Clinical Info].REMIND, [Patient Clinical Info].LETTERS
FROM (PATIENT LEFT JOIN NEWADD ON PATIENT.PAT_ID = NEWADD.PAT_ID) LEFT JOIN [Patient Clinical Info] ON PATIENT.PAT_ID = [Patient Clinical Info].PAT_ID
ORDER BY PATIENT.SURNAME;

The added field was [Patient Clinical Info].REMIND
 
What happens if you revert the query to its previous working state? Does it still work now or has something changed in you environment to stop it working??
 

Users who are viewing this thread

Back
Top Bottom