4. txtSearchStatus <-- value List : "Pending";"Fail";"Success"
I have check properly all macro inused and found nothing wrong with it.How ever if I search with BETWEEN [txtStartDate] And [txtEndDate] join with txtSearchStatus with "success" selected from dropdown VALUE LIST,sometimes I get correct answer say 200 success applicant,but always I get less then 200 success applicant listing.
Please someone tell me why?
NOTE : above search form always can get certain listing but not accurate as actual list.
Where are the search results displayed? In a subform, in a dynasheet display?
You say that you are clicking a first click, and a second click, and a third click, etc. Where are you clicking? Are you click, each of these times, on that same start button? Or, are you clicking somewhere else?
All three are from 1 mainform pass to second form with one click.The result is display on second form where with one GoBack button return to first form.
After return from second form[This is the form where all the results displayed.],and with the same search value again [txtSearchName,txtStartDate,txtEndDate,txtsearchSta tus] and click again the SearchButton, wooo, the result display normally different from 1st one or incomplete.