I have a form with 3 subforms side by side covering the real estate of the entire "Main Form". The data entry occurs in the middle form while the forms on the left and the right are queries that update data that others user are entering in at the same time. This DB has SQL back end.
My problem is that.... when a user..... enters in data and does not click the "save" button, but instead clicks one of the sub forms.... it saves the data...incomplete... or avoids all error checking. I've put the same code that is on my save button into the Before Update event.... and I continue to have problems.
I'm curious to know if anyone can think of a way that when a subform is clicked out of it doesn't save via the before update but instead just throws up an error message saying "You must click the save button".