drill down choices in form

[Guest]

When I enter a level 1 value I want a drop down box to show what choices are
available for the level 2 value. Then based on level 2 value another drop
down box and continue this through 5 levels. From level 3 on I want the next
available unused value. Example:
Level 1 choice is bldg1 (from lookup field of 10 values)

Level 2 choice is freezer1 (from some sort of filter that will only show
what is in bldg1

level 3 choice is rack (next number that has space available) from something
that somehow knows bldg1 freezer1 has 10 racks.

level 4 choice is box (next number that has space available) from something
that somehow knows bldg1 freezer1 rack(number assigned from level 3) has 80
boxes.

Level 5 choice is vial (next number that has space available) from something
that somehow knows bldg1 freezer1 rack(number assigned from level 3) box
(number assigned from level 4) has 100 vials.

End result is a location bldg1Freezer1Rack3Box45Vial945.

I have an Excel spreadsheet that shows all possible combinations but don't
know how to take a lot of the redundancy out and then put it into Access.
All I am trying to do is find a way to take a new inventory item and store it
in the next available location after I have determined the building and level
2 container.

Thanks for any help on this. This may be way too much for this type of
forum, if so I apologize.

 

[Ron2006]

It sounds like you are trying to bet something like cascading combo
boxes (and same thing can be done with listboxes).

Take a look at this reference from Doug Steele. It explains it all.

================================
http://office.microsoft.com/en-us/assistance/HA011730581033.aspx

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

================================

Ron