Gasman
Enthusiastic Amateur
- Local time
- Today, 18:33
- Joined
- Sep 21, 2011
- Messages
- 14,264
Hi all,
I have a simple form with an unbound combo on it.
In a subform I have a datasheet linked to the combo.
In the datasheet I can filter further for date and let's say telephone number, but any of the fields that are shown.
I wish to put a report button on the form to produce a report, but that only shows the data currently filtered on the datasheet.?
I'm fine with filtering for the combo for the report, but how do I add the rest of the filter criteria?
As an aside, if I filter on a date, that works fine, but if I then filter on a telephone number, I am presented with numbers that do not belong to the records already filtered?, and selecting an incorrect one filters the data to an empty datasheet.
Is there a way around this, as I must admit I thought it worked as per Excel?
TIA
I have a simple form with an unbound combo on it.
In a subform I have a datasheet linked to the combo.
In the datasheet I can filter further for date and let's say telephone number, but any of the fields that are shown.
I wish to put a report button on the form to produce a report, but that only shows the data currently filtered on the datasheet.?
I'm fine with filtering for the combo for the report, but how do I add the rest of the filter criteria?
As an aside, if I filter on a date, that works fine, but if I then filter on a telephone number, I am presented with numbers that do not belong to the records already filtered?, and selecting an incorrect one filters the data to an empty datasheet.
Is there a way around this, as I must admit I thought it worked as per Excel?
TIA