Why not simply assign the result of GetDocField to a variable, then test for IsError on that variable before building the string? Before FailSilent, we all did this all the time to avoid have two dblookups for every one we needed to do. I haven't had my coffee yet, so maybe I'm missing something obvious, but it sure seems like the same logic applies here.
Jake,
Why not simply assign the result of GetDocField to a variable, then test for IsError on that variable before building the string? Before FailSilent, we all did this all the time to avoid have two dblookups for every one we needed to do. I haven't had my coffee yet, so maybe I'm missing something obvious, but it sure seems like the same logic applies here.