filtering records

[crescent-centre]

I have a database to record drawings received. On the form there is a combo box to select discipline (Civil, Electrical, Mechanical) and a combol box to select the volume the drawings are in (Volume 1 - foundations, Volume 2 etc). The disciplines are stored in tblDisciplines with a relationship between this and the main tbldocument. I also have a table , tblLocation which has the volume ref and description. However when I click on the location field it shows me all volumes for all disciplines. What I want is if the first field selected is Civil only the civil volumes are displayed.
Can any one point me in the reight direction

 

[Rod D]

This looks like the classic "cascading combo box" question to me. Do a search in the forum on this - you will get lots of information.

 

[crescent-centre]

OK, followed your advice and have spent the last couple of hours reading up on cascading combo boxes. Followed a link www.fontstuff.com which gave a good example and easy to follow.
However although I select the discipline from the first box, which then displays the volumes in the 2nd box, there appears to be nothing stopping me going back through the records and changing the discipline without changing the volume. How do I add some form of error checking?

 

[neileg]

I presume you are using the AfterUpdate event of the first combo to requery the second. At the same time you could set the value of the second to null, so that you remove the previous entry.