I just noticed that when I add the TrackingActID portion of the filter and click Search, it returns fewer listings as stated previously And there is not blank line to add a new listing. Instead the * is next to the data for the last entry.
--- In MS_Access_Professionals@yahoogroups.com, mrsgoudge <no_reply@...> wrote:
>
> 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
>
Tidak ada komentar:
Posting Komentar