I am having an issue with Access 2016. When users try to save when they first input details into the emergency contact tab they receive an ODBC call failed error (screen shot attached). This database has an SQL 2008 R2 back end and I have checked the SQL table and the Surname exists in ServiceUsers so the value is not null.
If a user closes the tab by using the x button in the top right hand corner the details do save to the table. Is there a way to prevent this error occurring?
Any help would be gratefully received