bless

thanks guys got it going....cheers

thanks for the reply, yes i already have the database set up, i like your sugesstion on the extra field for keywords, and i would prefer to use javascript rather than VB. So i'll probably only be checking the name field because whoever is going to be using this will know what they are looking for its a matter of them being able to type there chemical correctly in the search, and give them there result. If you could send some example it would be greatly appreciated. thankscdeagazi@confederationc.on.caif anyone else can help i could still use it.

Hello all i hope i can find some help here.I did some looking and couldn't really find anything, this could be either my eyes didn't see it or i wasn't searching proper context. anyways ive made a database with MSDS's (material saftey data sheets), it consists of a Name, a location link, and an info space. all i need to do is create a search bar so a user can type in the product they want i.e Mr. Clean for example and my database will give them results. whether it parses 3 or 4 letters doesn't matter. if any one knows a good reference or can help me on this it would be greatly appreciated. oh and im using microsoft access and trying to stay with asp the college im working for tends to stick to what they are used to. im more of a designer/css kinda guy so i need the help i can getthankscarlo