Filter a datasheet

[mark curtis]

Dear all,

I have a tabbed control with many subforms on. The main form is filtered by ProjectID.

One of the subforms in datasheet format stores history of project issues, constraints and dependencies. What I want to do is select the field, which is a combo box holding text issues, constraints and dependencies. If I select issues then I want the datasheet to refresh and only show all issues for that ProjectID?

Thanks
Mark

 

[Rich]

Base the datasheet on a query, and use the criteria to limit the output