hi. i have a problem. i need to be able to search multiple tables in ms access useing any letter of the field and thenfor it to display it in a list to be selected.

egsample; the user is looking for a company with the name "Fred Blogs" so he types in "ed" clicks search then brings back the results of all values with "ed" in it in a list for him to select the right one.

please help i am really stuck on this

Regards
Matthew Allee

Computer Consultant
R Charles Associates

hi there..

you can use like in the where clause...

EX:

select * from anytable where field1 like "*ed*"

* inside the string means that can be any char (or a lot of them), you can use ? also to look for only one char.

HTH

Gonzalo

Public Function Supervisor_Search(Grid As MSHFlexGrid, Field As String, KeyWord As String)

    SQL = "select * from tblSupervisor where " & Field & " like '" & KeyWord & "%' order by Supervisor_Lastname"
    rs.Open SQL, conn
    Set Grid.DataSource = rs
    rs.Close

End Function

the Field is the Field in your database, and the keyword are the one's you input in your text box. Hope it helps...

mac ware that sounds like great help thank you for your post. im not sure tho coz im creating the program in vb6 to look at the microsoft table. im sorry i wasent clear on that from start i am using what you wrote to see if i can change it into vb6
regards matthew allee