Can edit query results

[GlenLynam]

Good Morning,

I am trying to edit the results for the following query but all it does is make a noise and wont let me edit the results, no errors or anything.

The query is as follows, please can someone tell me how to edit the results??

Thanks

SELECT Courses.CourseName, Courses.Description, Training.When, Training.NameOfTrainer, Training.Location, Training.Completed
FROM Courses INNER JOIN (Personal INNER JOIN Training ON Personal.PersonID = Training.PersonID) ON Courses.CourseID = Training.CourseID
WHERE (((Training.PersonID)=[forms]![Personal]![txtpersonid]));

 

[Remou]

You do not have an updateable recordset, by the look of it. Why do you need a join to personal when you are not referencing any fields in that table? If you want a query of this type to be updateable, you generally need at least one unique index.
You may wish to look at:
Harnessing the Power of Updatable Queries

http://msdn.microsoft.com/archive/default.asp?url=/archive/en-us/dnaraccess/html/msdn_harness.asp