Access Category Selection

ok is very simple but i don't know how to do it, i want in access to be able to select a category with two leves down. meaning A= main category - A1 SubCategory - A1-1 Sub-Subcategory. when i select A automatically selects A1 and A1-1 but if i only select A1 then only A1-1 /A1-2... so on will select. the porpuse of this is that i have a list of vendors and i want to be able to give them categories and them after i give them categories y do a search or query and find only the vendor that i want depending on the category that i select. in this is not clear please let me know i will try to explain better. regards Andres ## Deliverables i only need the VB code to put into the access. or a access file with this option alredy done. ## Platform windows xp - access 2003