one field to determine options in another field...how do you do it

[joemeshuggah]

im a novice with access and cant seem to figure out how to perform what i
would believe to be a simple task...

background:

-i have a main table that houses 'request' information
-within that table i have three fields that are based on other tables, those
being "region", "department", and "requestor"

-the department table lists the department, along with the region to which
it belongs
-the requestor table lists the individual's name who is making the request,
and the department to which they belong

what i want to happen
-i have drop down boxes for each of these three fields on my main form
-when i choose the region, i would like the options in the department field
to be limited to only those that belong to the region selected

-once the department is selected, i would like the options in the requestor
field to be limited to only those that belong to the department selected

where do i begin?

 

[KARL DEWEY]

Search on 'Cascading Combo' for your answer.

 

[joemeshuggah]

im still having trouble. i was able to get the department to filter down
based on what was selected for region, however, i'm not sure how i can now
get the requestor to filter down based on region. i tried pasting the same
code used for the first filter (department filtered on region), but only got
errors.

i tried searching on multiple cascading combos and found nothing. how
should i go about doing this? any suggestions??