Filter by combo box & text box?

[sparkyboy2406]

Hi Guys,

Please find attached my sample database.

If you select forms and then click "frmResults". The click the search button.



When i select Name from the combo box and enter a name it will return any record with that name.

My problem is with the telephone number. I need to be able to select "Telephone" from the combo box and enter a telephone number into the text box. When i select search the query should search all 3 telephone fields in the master table. (Daytime, Evening and mobile)

I think i need a LIKE or statement but cant get it working

Any ideas guys?

Thanks for reading and i appreciate any help!

A greatful novice

[NassauBob]

Is the doing of this in VB and not with an underlying query purely academic, or do you have a working reason for it? This would be a piece of cake with a couple of queries.

[sparkyboy2406]

hi,

the task must be done in VB. The name will filter. but i need to have the VB code to filter by telephone no. And this field must search the 3 telephone fields in the table.

can you help??