Cannot edit anything on my form/subforms!

[RichS]

I have created a database to keep track of the treatment of patients in a GP surgery who are on particular drugs. All the data is initally imported from an existing clinical database.

I have created a form that is tabbed and has subforms. The first tab displays the patient information. This information comes from two of the tables imported linked by patient ID so uses a query to achieve this link. The second tab has a continuous subform detailing the drug(s) the patient is on. Again, this is based on a query to link the patient to the drug(s) with patient ID. The third tab is similar to the second but to list test(s) the patient has had, again with a query and linked with the patient ID. The final tab is based on a seperate table created within the database to hold additional information that is not available from the imported data. Again, this is linked to the patient with the patient ID.

Unfortunately, due to the confidential nature of the imported information, patient details cannot be in the same table as the details in each section. They are only allowed to carry the common patient ID as a link.

All forms and subforms have been set to allow edits/deletions/additions etc. and all fields are enabled and unlocked.... But I cannot edit any of the details!

Can anyone advise on a solution to my problem?

 

[boblarson]

check each query to see if you can edit data in it directly. If not, then it isn't updateable.

Perhaps this will help too:
http://allenbrowne.com/ser-61.html

 

[RichS]

Thanks for replying so quickly!

No, I can't edit the details in the query. Does this have something to do with the way the query is created? It is not saved under the queries tab of the database window, but was created in the Record Source property. Could this be the reason? How can I make the query editable?

 

[boblarson]

Thanks for replying so quickly!

No, I can't edit the details in the query. Does this have something to do with the way the query is created? It is not saved in the queries tab, but was created in the Record Source property. Could this be the reason? How can I make the query editable?

Check that link that I gave you. Chances are it will show you where you have a problem.

 

[RichS]

Thanks again for the help. I've looked at the possible causes for my queries being read-only from the link given and think that it may be because the Patient ID that I am using for the join between tables is not a unique index, although it is indexed and each record has a unique primary key. I am unsure how I would get round this as in all the tables there may be duplicates of the patient ID and this is the only common field between the tables.

Could anyone advise on the best way around this problem?

 

[boblarson]

you could try posting the database for us to take a look at (removing any sensitive data of course). Follow these instructions to post:
http://www.access-programmers.co.uk/forums/showthread.php?t=140587

 

[RichS]

Unfortunately, all my data is sensitive and it would be quite a task to produce sample data with this complexity. However, after following the link, it appears that I can now edit the data when I run the revised query. The only problem is that the form based in the query is now showing no data! What would make a form do this when the query it is based upon is returning the data correctly?

 

[Dennisk]

what I suspect you are doing is creating a one to many query for each subform.

If so then remove the queries and just select the correct table. Then ensure your subforms have the correct master/child link on the properties tab for the subform.

 

[RichS]

This appears to have worked. Thank you!

There are a couple of tabs which are still not editable, but that's fine as I didn't want them to be. They are just logs of previous events. But now it is possible to amend the main patient data and everything appears to be running smoothly. Thanks again...