Excel like autofilter query

[CCC]

Our company have used Excel to filter out documents base on date,
from_company, type_of_documen t, 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.

[MGFoster]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Try Filter by Form. Form the Access Help file:

"Filter By Form: A technique for filtering data that uses a version of
the current form or datasheet with empty fields in which you can type
the values you want the filtered records to contain."

On main menu select: Records > Filter > Filter by Form.

--
MGFoster:::mgf0 0 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQfXerIechKq OuFEgEQLHNQCglj R02NwNpWMb1inDN lS9zBvLa2cAnR9a
Rzk90Bkwy0/Hp1OG4PIyvgA0
=fH0R
-----END PGP SIGNATURE-----
CCC wrote:

Our company have used Excel to filter out documents base on date,
from_company, type_of_documen t, 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.