Search results

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...

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...

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...

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...