Masters of Access - I need Assistance!!!

[billythedj66]

We have created a database of electric panels for a complex where I work. In this complex there is four buildings with twenty five electrical rooms total. Each room has four electric panels, therefore we have 800 panels. Each panel has it's own designation number. This is the primary key. I have created a List Box Search that enables the user to search by panel designation that then open that particular record. My question is how can I do multiple filtering list boxes to make searching easy.

Example: 1st List box lists the four buildings, after selecting the appropriate building, the second list box will contain those room numbers in that particular building. After the room number is selected, the final list box will only the panels in that room of that building. I hope I am stating this clearly enough.

FYI - I am using Access '97

Please help!!
Thank You in Advance

 

[Fletchmeister]

I have recently had this issue with a project I have been working on. Go to Article 209576 on the Microsoft Knowledge base, this is a solution for Access 2000. If like my company you are using Access 97 then you will need article 98660.

Good Luck (it does work!)

Fletch

:wink: