[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

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 7
• New Files 1

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___