Unanswered: Linking information to two combo boxes
The problem I have is I have two combo boxes one contains tasks and the other contains subtasks. What I want to do is when I select a task the associatted subtasks populate the sub task combo boxes and have the abilility to select one. The combo boxes appear in a sub form and right now for the row source under the sub task combo box is SELECT [Sub_Tasks].[Sub_Task], [Sub_Tasks].[Task] FROM Sub_Tasks WHERE ((([Sub_Tasks].[Task])=[forms]![ResponsibilitiesCurrent]![ResponsibilityCurrent_subform]![Task]));
Where ResponsibilitiesCurrent is the main form name. What happens is when I try to select a sub task I get a prompt telling me to enter a parameter and when I take out the sub form name from the row source the sub task combo box is empty.