Hi there, me again
Im trying to create a form that has several list boxes: the first looks up values from a table, the 2nd will look up values from a query using an ID number from the first, the 3rd will look up values from the same query based on another ID key that is selected from the 2nd list box.
The idea is that the first list box will be used to choose a Project.
The 2nd list box will then bring up all the workpackages within the Project selected from the first listbox, that has a level 1 in the StructureID.
Then the 3rd will be used to select Workpackages with a Level 1, selected from the 2nd box, and a level 2 in the second StructureID field.
I'm sure this is possible, but I don't know how to go about basing one list box on another list box and so on.
If someone can help me with this it'd be much appreciated.
Cheers
Im trying to create a form that has several list boxes: the first looks up values from a table, the 2nd will look up values from a query using an ID number from the first, the 3rd will look up values from the same query based on another ID key that is selected from the 2nd list box.
The idea is that the first list box will be used to choose a Project.
The 2nd list box will then bring up all the workpackages within the Project selected from the first listbox, that has a level 1 in the StructureID.
Then the 3rd will be used to select Workpackages with a Level 1, selected from the 2nd box, and a level 2 in the second StructureID field.
I'm sure this is possible, but I don't know how to go about basing one list box on another list box and so on.
If someone can help me with this it'd be much appreciated.
Cheers
