Connie-
Please post your code.
John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of mrsgoudge
Sent: Thursday, May 19, 2011 7:35 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Filter not working correctly
Hi all,
Once again I'm using the header with unbound boxes to create a filter for the
detail section of the form. Am encountering a problem:
1. Wrongs records returned if the Clear Filter button is not used before a new
search. For example: The form loads and a filter is made in code to show
records for the previous 31 days. That works. But when I fill in another
cbobox to filter on TrackingActID, I get strange results. If the original 31
day filter had 9 records, when I add info to the unbound TrackingActID cbobox &
press the Search button, the least current 5 records are returned irregardless
of the trackingActID number. i.e. the original search results are returned
minus the most current 4 records. If I click search again, it many return the
same 5 records, but once I click several times 4 records are returned with the
correct results. e
I know I can add Me.FilterOn.Off at the beginning of the Search button's code,
but I'd like to understand why. How long does strWhere retain information?
thank you!
Connie
------------------------------------
Yahoo! Groups Links
Kamis, 19 Mei 2011
RE: [MS_AccessPros] Filter not working correctly
__._,_.___
.
__,_._,___
Langganan:
Posting Komentar (Atom)
Tidak ada komentar:
Posting Komentar