Populate combo boxes from results of other combo boxes

[matt.pimm]

Hi All,
I have seen many topics relating to this subject, but i'm still quite
confused.

I have a database structure that has Releases
Each release has main tasks
Each main task has sub tasks
Each sub task has work items

I want to create a form that will allow me to have a combo box
containing the releases. Once the release is selected, the relevant
main tasks will be displayed in another combo box, then the sub tasks
and finally the work items in a table view.

Does anyone have an example of this or know where one can be found?

Thanks

Matt

 

[Al Camp]

Matt,
The value selected in cboReleases is used to filter the query behind
cboSubTasks.
The value in cboSubTasks is used to filter the query behind cboWorkItems.

In the query behind cboSubTasks the [Release] field (hidden) should have
a criteria of...
= Forms!frmYourForm!cboRelease.
In the query behind cboWorkItems the [SubTask] field (hidden) should have
a criteria of...
= Forms!frmYourForm!cboSubTasks.

Use the AfterUpdate event of cboRelease to Requery cboSubTasks so that
cboSubTasks will always be "in synch" whenever cboReleases changes.
Same with cboSubTasks...