Replies

Yes. Compact and Repair did nothing. I did re-evaluate the function and re-wrote them to work, however in one instance I received a circular reference. The function not working is: Mileage: IIf(IsNull([DealerDefined1]),[Vehicle]![Mileage],[DealerDefined1]). When I take out the ISNull then circular reference rears its head, so I am left to do this: Miles: IIf([Mileage]=0,[DealerDefined1],[Mileage]).

This seems simple enough, but even at SP2 I get notta. I have noticed that 97 will let you do some things wrong then all of a sudden it comes to life like this and not let you past go….. And, I am using a 2-week uncorrupted database plus the one that went belly up. With the two acting the same, I’ll have to concede that perhaps the functions where not right to begin with??

What do you think??

I used your suggestion and found it to work using the full name of the mail server as a suffix. Thanks again for your assistance.