searching a dbase

[lancemeroniuk]

Hi all..

I have a dbase for all my cd's for my dj company. Is there a way for access to list all the possilbe titles or artists for say a 3 letter input. IE: if I were to type "TWA" as a artist name... could it come up with Twain Shania or any other possiblies?

Thanks in advance

Lance

 

[dcurtis]

Build a query on the table that holds the data you want to search. In the field criteria for Artist (or whatever your field name is you want to search) add:

Like "*" & [Artist Name] & "*"