I have a continuous form, with some text fields, some date fields, some combo boxes, and some numeric fields.
I'd like to be able to filter the records, with the option to base the filtering on a number of the fields or just one or two (depending on requirements), but not via criteria set in the header of the continuous form. (I've found lots of examples and tutorials on how to filter that way). Instead, to have more 'room' for setting the filter criteria than would be possible in the header, I'd like to be able to click on a 'Filter records' button in the header of the continuous form, to open a 'Filter records' single form. Once I've set the criteria (could be one field or a number of fields) in the single form, I'd like to click an 'Apply filter' button, and have the records in the continuous form filtered accordingly. Is this achievable ?
I'd like to be able to filter the records, with the option to base the filtering on a number of the fields or just one or two (depending on requirements), but not via criteria set in the header of the continuous form. (I've found lots of examples and tutorials on how to filter that way). Instead, to have more 'room' for setting the filter criteria than would be possible in the header, I'd like to be able to click on a 'Filter records' button in the header of the continuous form, to open a 'Filter records' single form. Once I've set the criteria (could be one field or a number of fields) in the single form, I'd like to click an 'Apply filter' button, and have the records in the continuous form filtered accordingly. Is this achievable ?