Hello All.

Here's the scoop. I have Tasks and SubTasks. For certain tasks there are predefined subtasks associated with them. I have a form setup with multiple subforms. Basically, when the user goes into the form, the select a task from a drop down, and it filters the data based on that task. After that they use record navigation command buttons to navigate the subtasks. How do I set up the SubTasks to be a drop down? Basically, I know that the drop down can't be linked to the subtask field that is in the table because it would essentially change that current subtask. Basically I use the Docmd.ApplyFilter command for the Task on an after update when the use selects it from the drop down, but I'm having difficulties doing the same for the subtask area. Does anyone have any examples or advice they can give me?

Thanks, John

Have you used

LinkMasterFields
LinkChildFields

to link the subform to the task?

If not, that is the way to go

As far as dropdowns.. why can't you use a dropdown for the subtask? What is the applicable table structure?

Yes, I'm currently using that. tblCorpTasks has CorpTaskID(AutoNumber), TaskID, etc. tblCorpSubTasks has CorpSubTaskID, SubTaskID, CorpTaskID, etc. They are linked by CorpTaskID. Basically, I want to make the SubTask a drop down so that the user can select the sub task in the sub task area. I've got it set up to where there is a subtask table with predefined subtasks, and each subtask is associated with a particular task. Some tasks have a few subtasks. I want the form to work like this. The user selects the task, and from there, only subtasks are available to select from that particular task. Thanks for any assistance.

please specify...

for the main taskid -->

formname:
Control Name:
ControlSource:

for the combobox dropdown of subtasks -->

please paste in the SQL of the rowsource
(from the menu: VIew, SQL)