Search box within access or third party addon to do such?

[Ratedr]

I have an access database with 6 columns. I am putting in an
inventory of all of my items 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 width weight notes
sample 1abc 5 2.2 2.1
sample 1add 3 2.5 2.1 for turning
stock 3bbb 3 2.6 2.2 for acess
sample 1off 12 4.4 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. If Im not
explaining myself correctly, please let me know I can send a
screenshot of my database, and a picture I drew of what Im looking for

 

[Allen Browne]

If you want to just search on one field at a time, see:
Find as you type - Filter forms with each keystroke
at:
http://allenbrowne.com/AppFindAsUType.html
This one is very easy to implement.

If you want to create a search form that lets you search on any combination
of fields, including ranges, and ignoring any boxes the user leaves blank,
see:
Search form - Handle many optional criteria
at:
http://allenbrowne.com/ser-62.html

 

[i_takeuti]

I have an access database with 6 columns. I am putting in an
inventory of all of my items 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 width weight notes
sample 1abc 5 2.2 2.1
sample 1add 3 2.5 2.1 for turning
stock 3bbb 3 2.6 2.2 for acess
sample 1off 12 4.4 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. If Im not
explaining myself correctly, please let me know I can send a
screenshot of my database, and a picture I drew of what Im looking for