Criteria problem in a select in Row Source

[XfredX]

Hi,
I have something that looks simple but that I cannot solve.
I have 2 tables 1 table TASK, and table SUBTASK.
I m creating a timesheet Table to record time for each SUBTASK, table is as follow : TASK,SUBTASK,TIMESPENT.

I want a form to let fill the timesheet table where the user can choose the task from a combo list, and then the subtask form another combolist. The 2nd combolist should only show the SUBTASK belonging to one Task.
For the SUBTASK I have row source Type and as TABLE/QUERY and in the Row Source I ve put a SELECT with a criteria such as: WHERE SubTask.SubTaskID=Form!TaskID;
On the form, whatever the row i used, the result is always the same whatever the TaskID. It seems that Form!TaskID always keep the same value.
Any advice?
Thanks a lot
Fred

[NeoPa]

Check out (Example Filtering on a Form). This is not exactly what you're after but it does include the filtering technique you need.
Also, make sure your ComboBoxes are bound to the underlying table on your form. That way the results selected can be save easily in the new record.

Let us know if this helps and how you get on :)

[XfredX]

Thanks very Much, I succeed by using some refresh function on the main form, I don t know if it is the best solution, bu it works well

[NeoPa]

I'm glad you found a resolution :)
Refresh is good, but if any records are added or deleted then a .Requery will be required instead. Refresh only re-grabs the data for existing records. Requery reruns the whole query.