Charlotte Foust
cfoust at infostatsystems.com
Wed May 28 15:56:44 CDT 2003
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. Charlotte Foust -----Original Message----- From: Don Elliker [mailto:delliker at hotmail.com] Sent: Wednesday, May 28, 2003 11:01 AM To: accessd at databaseadvisors.com Subject: [AccessD] Query reference to screen control 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 =[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? _d "Things are only free to the extent that you don't pay for them." _____ MSN 8 helps ELIMINATE E-MAIL VIRUSES. <http://g.msn.com/8HMOENUS/2743??PS=> Get 2 months FREE*. -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030528/1116386b/attachment-0001.html>