I have an Access Project linked to SQL 2008 R2. My problem is with a form I have that is using a view.
The majority of the data I can validate using the BeforeUpdate Event, but I have 2 fields that cannot contain nulls. I have this specified in the base table, but unfortunately the form gives me a system error message before my BeforeUpdate event triggers. I want to give the end user a more friendly message than the confusing system message.
I know I could allow nulls in the base table, and check data entry at runtime, but I would prefer to keep the base table the way I have it.
Is there another event that I am missing?