Database Search filter

[dada123]

Hi! I'm totally new to microsoft access, I'm doing a simple search engine in my form.. that onchange of the textbox value, it will filter the result without pressing any button. anyone can help me with this function? thanks in advance!

here is the scene of my form: i have a textbox and has the label named title.. below the textbox is a subform/subreport that displays all the values in the table..

 

[SteveSchapel]

Dada,

How do you want it to do this filtering? Based on the value of one of the fields in your table? Or more than one field subject to the criteria you type into the textbox? And you want exact match, or "contains" match? Can you give some specific examples?

Is Title the name of the textbox? What is the name of the subform? What is the name of the table? What is the name of the field that you want the criteria to apply to?

 

[dada123]

thanks for the reply.. i have figured it out already.. thanks! i really appreciate your time for replying..

 

[SteveSchapel]

Thanks, Dada.

If you feel so inclined, you might like to post details of what you figured out, for the potential benefit of others who may also be interested.

 

[dada123]

sure.. i will.. umm.. i'll just finish some important stuffs in my work..