<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Message</TITLE>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2800.1170" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=796025520-28052003><FONT face="Comic Sans MS" color=#0000ff
size=2>I've seen both 2000 and 2002 do something like this when they had a
flakey reference. Nothing was shown as missing in the references, but
calls to a particular library failed until the reference was reset and some
comboboxes with form references in the query criteria came up
empty.</FONT></SPAN></DIV>
<DIV><SPAN class=796025520-28052003><FONT face="Comic Sans MS" color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=796025520-28052003><FONT face="Comic Sans MS" color=#0000ff
size=2>Charlotte Foust</FONT></SPAN></DIV>
<BLOCKQUOTE style="MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Tahoma size=2>-----Original Message-----<BR><B>From:</B> Don Elliker
[mailto:delliker@hotmail.com] <BR><B>Sent:</B> Wednesday, May 28, 2003 11:01
AM<BR><B>To:</B> accessd@databaseadvisors.com<BR><B>Subject:</B> [AccessD]
Query reference to screen control<BR><BR></FONT></DIV>
<DIV>
<DIV>
<P>I have this odd occurrance in A2K. I have a combo that has criteria
referencing two screen controls, like this
[forms]![frmtestcases]![cmbproject]. Many times (but not always) it returns
nothing when I click it. Then if I go into the grid for the underlying query
and make it </P>
<P>=[forms]![frmtestcases]![cmbproject] it works, however it does not keep the
equal sign, it discards it - works for a while then craps out. What gives??
Just another wierd Accessism?</P>
<P>_d</P></DIV>
<DIV></DIV>
<DIV><FONT face="Geneva, Arial, Sans-serif" color=#6666ff size=2><EM>"Things
are only free to the extent that you don't pay for them." </EM></FONT></DIV>
<DIV><FONT color=#33cc66></FONT></DIV>
<DIV></DIV>
<DIV></DIV>
<DIV></DIV>
<DIV></DIV>
<DIV></DIV>
<DIV></DIV>
<DIV></DIV></DIV><BR clear=all>
<HR>
MSN 8 helps <A href="http://g.msn.com/8HMOENUS/2743??PS=">ELIMINATE E-MAIL
VIRUSES. </A>Get 2 months FREE*. </BLOCKQUOTE></BODY></HTML>