Greetings:

I appologize in advance if this topic is redundant.

I have a friend that wants me to create a google-type search for his jewelry db. Here is what he asked for in his own words:

"I have an access database with 6 columns. I am putting in an
inventory of all of my ring styles with their corresponding sizes and
weights, etc. I will have over 2000 lines/records when I am done.
What I want to do, is either create something withing Access, or find
a third party add0on, that will allow me to search within the fields,
and return the corresponding results
here is what I have for example

category style size karat weight notes
RBI 6rbi 5 14 2.1
RBI 5rbi 3 14 2.1 for turning
tapered HL 3frthl 3 18 2.2 for acess
tapered 6st/085 12 18 12.5


what I want, is to be able to create a form or a GUI or something that
will allow me to search within this database. For example I want a
box that says category = and I would type in Sample and it would give
me all of the styles that fit in that category."

I don't want to agree to do this unless I'm sure I can do exactly what he is asking.

I am relatively new to Access so, I am just unsure how to approach this. I feel confident I can do it though, with some help.

Thanks so much for any help.

Should be very possible, search the forum or check out the thread I've posted below.

http://www.access-programmers.co.uk/forums/showthread.php?t=123219&highlight=Search+form

Thank you very much. I believe I found something that will suffice.