Setting up a Documentation Database

[gadric]

I am looking to build an Access Database with a single Table and multiple Fields.
The front end will have a variety of Drop Down Boxes that are meant to act as progressively more precise query.
I.E. The First Drop Down Box will contain Choices from the First Column in the Table.
Once the First Drop Down is chosen it will exclude all the entries that do not match that choice in the first Column
Then One moves on to the Second Drop Down Box when the user will choose a value that will further narrow the search criteria, Then one moves on to a Third Drop Down Box and so on until the solution is reached
I would compare it to a VLookup command sort of operation in Excel.
Any ideas?

[ssanfu]

Not too hard...(but forget about Excel - things in Access work different than Excel).

You would be creating a filter that is applied to the form. Each combo box would call the code - the filter would progressively grow.
See this article - the code is here

You will have to modify the code to meet your requirements.