All - thanks for any help. I can't find this answer.
I the attached DB - There is a form [Holdings_List] with 4 multiple combo boxes used to filter the table.
I cannot figure out how to get them to all work "together". What I want is...
1) The form opens with no records showing
2) When the first selection is made from the Account OR FromDate\ToDate combination OR Security the selected values are shown
3) When the second field value is selected the list filters to only show the First Selection AND the Second Selection
4) When the third field value is selected the list filters to only show the First AND Second AND Third selections
5) If the user blanks out a 3 filter, the remaining filters are applied with the same AND approach.
I already have the [Forms]!.etc... criteria setup in the query and the OnClick even for all 4 fields.
My guess is I have the query criteria incorrect
FYI's
- The related query is embedded in the form Record Source
- A relevant date range for testing is 4/1/20 - 4/30/20
- The [FromDate] and [ToDate] have to work together in a between statement. Selecting only one of the should not filter the data
- I do not want to cascade the data in the combos, using the value selected in one combo to impact the list in the next.
I really appreciate any help. I'm stuck.
I the attached DB - There is a form [Holdings_List] with 4 multiple combo boxes used to filter the table.
I cannot figure out how to get them to all work "together". What I want is...
1) The form opens with no records showing
2) When the first selection is made from the Account OR FromDate\ToDate combination OR Security the selected values are shown
3) When the second field value is selected the list filters to only show the First Selection AND the Second Selection
4) When the third field value is selected the list filters to only show the First AND Second AND Third selections
5) If the user blanks out a 3 filter, the remaining filters are applied with the same AND approach.
I already have the [Forms]!.etc... criteria setup in the query and the OnClick even for all 4 fields.
My guess is I have the query criteria incorrect
FYI's
- The related query is embedded in the form Record Source
- A relevant date range for testing is 4/1/20 - 4/30/20
- The [FromDate] and [ToDate] have to work together in a between statement. Selecting only one of the should not filter the data
- I do not want to cascade the data in the combos, using the value selected in one combo to impact the list in the next.
I really appreciate any help. I'm stuck.