<html><div style='background-color:'><DIV>
<P>Yes, you got it in A2k the filteron is set to true then the filter is applied filteron=false and a requery will get you everything. As to the version thing maybe check the database name extension? Since I think this Filter thing applies to all recent mdbs<BR><BR>hth,</P>
<P>_D</P></DIV>
<DIV></DIV>
<DIV></DIV>>From: "John W. Colby" <JCOLBY@COLBYCONSULTING.COM>
<DIV></DIV>>Reply-To: accessd@databaseadvisors.com
<DIV></DIV>>To: "AccessD" <ACCESSD@DATABASEADVISORS.COM>
<DIV></DIV>>Subject: [AccessD] Differences - AXP and A2K
<DIV></DIV>>Date: Fri, 11 Apr 2003 13:33:28 -0400
<DIV></DIV>>
<DIV></DIV>>Folks,
<DIV></DIV>>
<DIV></DIV>>I have an instance where I want to hide a rather complex form instead of
<DIV></DIV>>closing it - to eliminate the load time. The user runs a "filter" form
<DIV></DIV>>which allows them to select a set of clients / claims, select one, then
<DIV></DIV>>"open" the claim form. they do this dozens of times a day.
<DIV></DIV>>
<DIV></DIV>>By hiding the claim form instead of closing it when they are done, I
<DIV></DIV>>eliminate the load time which is significant. Basically, the form loads
<DIV></DIV>>with all claims loaded, then filters down to one specific claim when
<DIV></DIV>>"opened" from the filter form - literally a filter is applied to the claim
<DIV></DIV>>form after opening. Applying this filter to an already open form in XP
<DIV></DIV>>works correctly, the form filters to the new record. Doing so in A2K does
<DIV></DIV>>not remove the filter. I vaguely remember running into this a year or more
<DIV></DIV>>ago - having to set the AllowFilter property to no, then back to yes or
<DIV></DIV>>something similarly obscure.
<DIV></DIV>>
<DIV></DIV>>Has anyone seen this and do you have the answer to how to make this work in
<DIV></DIV>>A2K? Also, this is obviously an A2K problem, so how do I sense that this is
<DIV></DIV>>an A2K FE so that I don't apply the fix to an AXP FE unnecessarily?
<DIV></DIV>>
<DIV></DIV>>John W. Colby
<DIV></DIV>>Colby Consulting
<DIV></DIV>>www.ColbyConsulting.com
<DIV></DIV>>
<DIV></DIV>>----------------------------------------------------
<DIV></DIV>>Is email taking over your day? Manage your time with eMailBoss.
<DIV></DIV>>Try it free! http://www.eMailBoss.com
<DIV></DIV>>
<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>Help STOP SPAM with <a href="http://g.msn.com/8HMDENUS/2731">the new MSN 8 </a> and get 2 months FREE*</html>