I am having trouble forming a query to create a simple report. The report information is coming from two different tables I beleive. My ultimate goal is to create a report to veiw Task Names from a specific Task List. On the form I want to select the task list from a combo box and report all the tasks from that list. Here are the two tables; checklistTable, which holds checklistID and checklistName. And taskTable, which holds checklistID and taskName. Any help with this would be most appreciated.

Sic

Sounds like you want cascading combo boxes. Do a search in these forums.