SubForm Filter

[rwalle]

Hi :

I have done a form with a subform inside to filter customers, the form have a Text box where user write down a name then I take this text box data as a criteria to the query wich subform data is tied to, then using a click event in a form button I run requery Comand and this way I can filter data to be showed, so far it works , now I want to add 2 more filter criteria TextBoxes to the same form in order to make it flexible so when no customer name is known the user can search using customer Phone number and other TextBox / button to search unsig the customer number I know it can be done but guess requery is no the right comand to apply diferent filter depending on what criteria user want to use, do somebody have an insigth to solve this . . .

Thanks in advance for your help

Raymundo Walle

[NeoPa]

Check out Example Filtering on a Form.

Ultimately, you would be using the .Requery(), but there is a little more to it than just that.