Subform

V

Vesta

I have a main form with 3textboxes.
Currently subform will display data if ONLY the 3textboxes are input
if only 2 or 1 is input, the subform will not display the data even though
there is data in the table.
My requirement is for the subform to display the data whenever
any 1 of the textbox is input.
Pls help.
 
A

Allen Browne

The solution will depend on how you are limiting the data: via query? via
filter?

For an efficient solution, see:
Search form - Handle many optional criteria
at:
http://allenbrowne.com/ser-62.html
It does involve writing some code, but it also explains how to do it in
queries if you really want to go that way.

If you only need to search on one field at a time, this one is simpler to
set up:
Find as you type - Filter forms with each keystroke
at:
http://allenbrowne.com/AppFindAsUType.html
You just copy a combo box (where you choose the field to search on), a text
box (where you enter the value to find), and set one property.
 
Top