One form to control it all?

[SteelFire]

I am running the database for the company that I work for, and my boss wants
some new things added. What I have is a huge Table of all the parts that we
have ever designed. I am now starting to add more tables that link the
customers and what not, but to the question. He wants a way to look up the
part he needs so that it does not have to be redrawn. He wants some pull down
boxes of the different categories and types of parts as well as a way to
search through the descriptions of the parts. Then wants a list of the parts,
and all in a user friendly way. I was thinking about having pull down boxes
on a form that would act as a filter for a query. Then a text box that would
act the same way. Then some button that I could hit that would run the query
and give me a list, or if it could get me a report, even better. I have
looked and found little help in the MS help. I know that there has got to be
some way to do this, I just don't know how. I don't know VB at all, and know
some SQL commands, but if the only way to do it is using VB or SQL, then I
will learn.

Any help is welcome.

 

[golfinray]

Your best bet is to either use the model Allen Browne has at
www.allenbrowne.com or Mr. Green has at www.fontstuff.com
I downloaded the little sample database at www.fontstuff.com and just
modified it to fit my needs.

 

[SteelFire]

Your best bet is to either use the model Allen Browne has at
www.allenbrowne.com or Mr. Green has at www.fontstuff.com
I downloaded the little sample database at www.fontstuff.com and just
modified it to fit my needs.

I am running the database for the company that I work for, and my boss wants
some new things added. What I have is a huge Table of all the parts that we

[quoted text clipped - 13 lines]

Any help is welcome.

Thank you so much. Mr. Green's site looks like it has just what I was looking
for. Out of all of the places I have gone, you have been the most helpful.
Thanks again.