R
ryan_eng
Hello,
I read the answer to Don Rudds question on "How combo box row source query
be conditional on another control". I have a similar problem (I think) but
can't seem to figure out how to incorporate that answer.
Basically I have a time tracking subform in datasheet view, where the
employee selects what type of activity they have worked on (Drawings,
Documents, Action Items or Other) from a drop down list in the first column.
The second column will allow the selection of a task from a combo box. The
third column combo box needs to show the drawings / documents / action items
related to that task. This requires the source of the combo box to be based
conditionally on the previous two selections (activity and task). How would I
set up this combo box and query in design view, and if this isn't possible,
the SQL code required. Also, if the activity "other" is selected, the third
column needs to act as a simple text box for free text entry.
My boss wants this feature, so help is MUCH appreciated.
Thanks
RYAN
I read the answer to Don Rudds question on "How combo box row source query
be conditional on another control". I have a similar problem (I think) but
can't seem to figure out how to incorporate that answer.
Basically I have a time tracking subform in datasheet view, where the
employee selects what type of activity they have worked on (Drawings,
Documents, Action Items or Other) from a drop down list in the first column.
The second column will allow the selection of a task from a combo box. The
third column combo box needs to show the drawings / documents / action items
related to that task. This requires the source of the combo box to be based
conditionally on the previous two selections (activity and task). How would I
set up this combo box and query in design view, and if this isn't possible,
the SQL code required. Also, if the activity "other" is selected, the third
column needs to act as a simple text box for free text entry.
My boss wants this feature, so help is MUCH appreciated.
Thanks
RYAN