<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1126" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>Virginia,</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>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.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2><A
href="http://www.mvps.org/access/modules/mdl0012.htm">http://www.mvps.org/access/modules/mdl0012.htm</A></FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Regards,</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>Steve Erbach<BR>Scientific Marketing<BR>Neenah,
WI</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>"Nothing so needs reforming as other people's
habits." - Mark Twain<BR></FONT></DIV></BODY></HTML>