Our company have used Excel to filter out documents base on date,
from_company, type_of_document, country to generate a list of where
the documents physical location is. The number of records have grown
to 8000 and I think it is time to use Access 2000 to handle those
records.
I am completely new to Access. So far I managed to make the selection
in combobox1 narrow down the list in combobox2, and combobox2 narrow
down combobox3 and so on. by adding some code in the afterupdate
property and source field of each combobox.
I am stuck on
1) how do I similate Excel autofilter feature that you don't need to
make your selection sequentially. for example, you can make selection
in any field and all other field's list is updated.
2) After I have made all the correct choice in each combobox of the
form I create, how do I list all records that match the query, and
print it out?
I have studied Access for 2 weeks and is completely clueless. Please
show me the direction.