Using SQL linked tables

I am converting Access data to SQL backend and Access front end. However I am having issues with all of my forms that "add a new record" or "duplicate a record". I get a "You can't go to specified record" error message when user clicks on "add record". All works fine in the old Access database. Tables are linked with ODBC connection to SQL tables. The forms involved all use a query with multiple tables in them. I have listed the SQL view of one query below. Any ideas would be appreciated!

SELECT DISTINCTROW Employees.Status, Employees.Loc, Monthly_Leave.ID, Employees.SSN, Monthly_Leave.LvCode, [Leave Codes].LvText, Monthly_Leave.Date, Monthly_Leave.LvDays, Employees.LastName, Employees.FirstName, Employees.Middle
FROM (Employees RIGHT JOIN Monthly_Leave ON Employees.ID = Monthly_Leave.ID) LEFT JOIN [Leave Codes] ON Monthly_Leave.LvCode = [Leave Codes].LvCode
ORDER BY Employees.LastName, Employees.FirstName;