<html><div style='background-color:'><DIV>
<P>Well, I never!..'flakey reference', indeed!! ;-) It's good to know someone else has seen it, thanks - I can assure you my references are impeccable- but I'll give them a peck anyway.<BR>_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>>From: "Charlotte Foust" <CFOUST@INFOSTATSYSTEMS.COM>
<DIV></DIV>>Reply-To: accessd@databaseadvisors.com
<DIV></DIV>>To: <ACCESSD@DATABASEADVISORS.COM>
<DIV></DIV>>Subject: RE: [AccessD] Query reference to screen control
<DIV></DIV>>Date: Wed, 28 May 2003 13:56:44 -0700
<DIV></DIV>>
<DIV></DIV>>I've seen both 2000 and 2002 do something like this when they had a
<DIV></DIV>>flakey reference. Nothing was shown as missing in the references, but
<DIV></DIV>>calls to a particular library failed until the reference was reset and
<DIV></DIV>>some comboboxes with form references in the query criteria came up
<DIV></DIV>>empty.
<DIV></DIV>>
<DIV></DIV>>Charlotte Foust
<DIV></DIV>>
<DIV></DIV>> -----Original Message-----
<DIV></DIV>> From: Don Elliker [mailto:delliker@hotmail.com]
<DIV></DIV>> Sent: Wednesday, May 28, 2003 11:01 AM
<DIV></DIV>> To: accessd@databaseadvisors.com
<DIV></DIV>> Subject: [AccessD] Query reference to screen control
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>> I have this odd occurrance in A2K. I have a combo that has
<DIV></DIV>>criteria referencing two screen controls, like this
<DIV></DIV>>[forms]![frmtestcases]![cmbproject]. Many times (but not always) it
<DIV></DIV>>returns nothing when I click it. Then if I go into the grid for the
<DIV></DIV>>underlying query and make it
<DIV></DIV>>
<DIV></DIV>> =[forms]![frmtestcases]![cmbproject] it works, however it does
<DIV></DIV>>not keep the equal sign, it discards it - works for a while then craps
<DIV></DIV>>out. What gives?? Just another wierd Accessism?
<DIV></DIV>>
<DIV></DIV>> _d
<DIV></DIV>>
<DIV></DIV>> "Things are only free to the extent that you don't pay for
<DIV></DIV>>them."
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>> _____
<DIV></DIV>>
<DIV></DIV>> MSN 8 helps ELIMINATE E-MAIL VIRUSES.
<DIV></DIV>><HTTP: 2743??PS="" 8HMOENUS g.msn.com> Get 2 months FREE*.
<DIV></DIV>>
<DIV></DIV>>_______________________________________________
<DIV></DIV>>AccessD mailing list
<DIV></DIV>>AccessD@databaseadvisors.com
<DIV></DIV>>http://databaseadvisors.com/mailman/listinfo/accessd
<DIV></DIV>>Website: http://www.databaseadvisors.com
<DIV></DIV></div><br clear=all><hr>MSN 8 helps <a href="http://g.msn.com/8HMJENUS/2752??PS=">ELIMINATE E-MAIL VIRUSES.</a> Get 2 months FREE*.</html>