Steven W. Erbach
serbach at new.rr.com
Thu Jan 30 09:03:00 CST 2003
Virginia, Might you not try using a substitute for DCount()? I've been using a set of replacements for all of the domain functions (DCount, DSum, DLookup, etc.) written by Trevor Best for some time. It will be slightly slower since a RecordSet variable is opened on the table in question...but it might do the trick. http://www.mvps.org/access/modules/mdl0012.htm Regards, Steve Erbach Scientific Marketing Neenah, WI "Nothing so needs reforming as other people's habits." - Mark Twain -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030130/2c0de4e9/attachment-0002.html>