And, that's also one of the problems with using macros as compared to VBA. With VBA you can get way more detailed information about your errors than macros can provide. If you are only comfortable with macros I would highly suggest working at learning VBA to get you much more power. (I've been there - I worked with Access databases for about 4 years before taking the plunge into VBA).