I have a form which I have to categorize all the items in inventory, in the heiarchy of department, category, subcategory. Now I wasnt sure on how to make the second and third dropdown boxes dependent on the input in the first. I seem to have it working with the sql statement I created for it. However, there is a problem with this. When I click on the drop down box and select the department, the category list will not update until I close the form and open it up again. Is there anything I can do about this to make the updating of the form drop down boxes real time? I am quite disappointed in access so far for stupid reasons like this...is there a way to get this working as desired?