Originally Posted by
Micron
...For such a long time I was under the impression that macros can't handle errors...
That's because they couldn't, until v2007! But even now, from what I hear, they don't do a really good job of it. Hard to tell, really, because very, very few experienced developers use Macros...they're simply not flexible enough!
And as June7 suggested...it's far better to check for duplicates before attempting to save a Record, than afterwards!
Linq ;0)>
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007