Search Records

[Rob]

Hello all,

i am trying to create a form in VB6 that will search
through 3 linked tables.

i have 3 comboboxes for the user to select the attribute
they wish to search under (with and and or functions for
a more defined search)

3 textboxes, each relating to the combobox used

when i click my search button how do i search all 3
tables for the information rewquired then compile a table
that just cointains the results to search??

thanks,

Rob