Why is this query un-updateable???

[mkelly]

SELECT [Job transfered to].[Job Number], [Job transfered to].[assigned to], [Job transfered to].[Start time], [Job Log in].[Client Number], [Job Log in].[Matter Number], [Job Log in].[Client ID#], [Attorney Profiles].[Client Name], [Job Log in].[Work Type] AS [Job Log in_Work Type], [Work Type].[Work Type], [Job Log in].[Number of Pages], [Job Log in].[Date / Time In], [Job Log in].[Targeted Completion Date], [PBMS Employee Name & Number].[Employee Number], [PBMS Employee Name & Number].[Employee Name], [Attorney Profiles].[Client ID number]
FROM [PBMS Employee Name & Number] INNER JOIN (([Work Type] INNER JOIN ([Attorney Profiles] INNER JOIN [Job Log in] ON [Attorney Profiles].ID = [Job Log in].[Client ID#]) ON [Work Type].ID = [Job Log in].[Work Type]) INNER JOIN [Job transfered to] ON [Job Log in].ID = [Job transfered to].[Job Number]) ON [PBMS Employee Name & Number].ID = [Job transfered to].[assigned to]
WHERE ((([Job transfered to].[Start time]) Is Null) AND (([PBMS Employee Name & Number].[Employee Number])=[Enter Your Employee Number]))
ORDER BY [Job Log in].[Targeted Completion Date];


I need the start time to be updateable and it use to work but recently decided it did not want to anymore.

 

[mkelly]

I am pulling data from tables into a query and running a form off of this. The form contains a macro on a button the when pushed places NOW() in to the start time field. it use to work but now it will not work on the form or query however, I can still update it in the table. I recieve an error message saying that;

the recordset is not updateable.

 

[mkelly]

all I did was change the program from 2000 to 2002