Hi there,
I'm new at VBA coding and the programmer for this database has other priorities as we're a small group so I'm a bit stuck at the moment and would really appreciate any help, as it's a small error but the database is near completion. Basically, I have different sub-forms in tabs and what happens is, if I click on a drop-down menu in a new row or enter in a value and than backspace it because I don't want to enter in a value and then click somewhere else I get the "No Null Error" and then have to select a "pretend value" and then delete that in order to move on. So I know the solution would be to have VBA code to:
* check whether all the rows are blank except for the applicantID and the other IDs and then ignore the null error"
* otherwise if there's another field that is not blank (i.e. I'm actually forgetting to put a value in one of the fields not trying to backspace) then prompt the error.
Thanks for any help - much appreciated
Enquiries