Tommy,
can I suggest you have a look at the tutorial I wrote some time ago on Dynamic Dropdowns here which has a sample database along the lines of what Jason is explaining to you.
Hopefully this will make things clearer to you.
I am on a mac also so I can't open your MS Access file