I have two look up tables in an access database. I want the results of the Colleges Look-up to filer out the results of the Departments look-up. I have used [Forms]![Form]![College] to do this. It works the 1st time but when I choose a different option for colleges the departments list remains filtered on the previous choice. It does not update.
How do I solve the update problem?