Filter data according to many criteria

[tanha]

Hello every body,
I have four text boxes and a subform on a form, the text boxes is suppose one is for the First Name, Last Name, Country, and Average and the subform includes all the data...

Wanted:
I want to filter the subform data at the ONCHANGE event of each text box, suppose if some want type letter A or a in First Name textbox, then all the data filtered which their First Name begins by letter A or a and if type more letter then according to those letter the data be filtered, and also if also type anything in the Last Name textbox, then according to the data in First Name and Last Name, the data must filtered...
How it is possible?

 

[boblarson]

Wanted:
I want to filter the subform data at the ONCHANGE event of each text box, suppose if some want type letter A or a in First Name textbox, then all the data filtered which their First Name begins by letter A or a and if type more letter then according to those letter the data be filtered, and also if also type anything in the Last Name textbox, then according to the data in First Name and Last Name, the data must filtered...

Unfortunately Access is not good at this and I think you will find that if you try to use the On Change event like this, you will only get frustrated because Access is NOT fast enough to be able to do this efficiently. You can type your criteria and then search, but it really isn't going to work for you to have it doing the search on the change of each character.

 

[tanha]

Thanks for the tips, but I dont have much data,I shall be very glad, if u plz guide me how to handle that...