I want a drop down list to affect the options in a second

[Guest]

For instance I want my user to select a building in one drop down box in a
form, then have that activate a second drop down box which has room numbers
for that building. Maybe after that another drop down box activates which
lists just the printers in the room you selected, and after you select a
printer another that shows what supplies are availible for that printer.

I know how to setup the relationships and add the fields into my form but if
I select a building in the first column I'll still see all the rooms for all
the buildings, and if I select a room I'll still have all the printers in all
the rooms and so on.

Any ideas would be very much appreciated.

Thanks,

 

[Douglas J Steele]

What you want is generally referred to as cascading combos.
http://www.mvps.org/access/forms/frm0028.htm at "The Access Web" is an
example of one way to accomplish it.