Rick's Thoughts:
Alex made another Access Tip video. In this one he shows you how to check the fields on a form to see if any of them are empty (null). He takes a unique approach allowing you to use the TAG property to specify which controls you want to check. I probably wouldn't have thought of that. Here's the tutorial on YouTube: