Update data on Microsoft Access Form via VBA - Issue 2

I had applied the code to the Access database and unfortunately it did not work. An error message was thrown up. I think it may have to do with the fact that the form I applied code gets the data from a SQL select query that uses 2 tables and ME.Dirty does not like it.

I'll have to investigate this further in work-time as the best way to get the problem fixed is by using the real database rather than mock-ups at home.