I am trying to create a database to track freezer inventory. I have a form to Search for inventory based on the location provided. The more information is provided on location, the more narrow the search result of items. The tree structure goes like this (each its own entity with PKey) - Freezer -> Shelf -> Rack -> Box -> Item.

All freezers (with Freezer ID column hidden) is listed in a list box. Each Freezer has 1-M Shelf, Each Shelf 1-M Racks...

I trying to make it so that when a Freezer is selected from a listbox, the Shelf combo box is then enabled and allows the user to only select from the shelves available for that freezer.

Please advise, Thanks!

See if this will work for you....

http://support.microsoft.com/support/kb/articles/Q209/5/76.ASP?LN=EN-US&SD=gn&FR=0&qry=q209576&rnk=1&src=DHCS_MSPSS_gn_SRCH&SPR=ACC2000

This is exactly the solution I'm looking for. I tried this and also tried what they suggested for the older version of Access (using a macro instead of VBA code). I am working with a list box and a combo box. Select from the list box to filter the combo box. The concepts should be the same, however, I can't seem to get it to work. Regardless of whether or not I select a Freezer from the list box, all shelves are shown in the shelf combo box - nothing filtered. What am I doing wrong?

The instructions still do not work? Am I doing something wrong? I went over it many times, and I even did what the instructions said to do on the Northwind sample database. The dependent combo box still does not filter anything. Please help!