I have a subform that has a dropdown field with some options and I also have a lookup field to a code catalogue, I would like that when the user choose an option in the dropdown the codes in the lookup field are filtered acording to the previous election.

How can I do this? any help will be appreciated.