date filter is not a field its just a variable of type text to get the date range from the user for filtering the subform
Then you can create a function in the subform like SetDateFilter which gets DateFilter as parameter. On the mainform call SubForm's SetDateFilter function on OnValidate and use a CurrForm.UPDATE on OnAfterValidate.
when i enter the date into the Date filter textbox it filters the subform fine but when i clear the Date Filter it does not remove the filter from the subform
when i enter the date into the Date filter textbox it filters the subform fine but when i clear the Date Filter it does not remove the filter from the subform
You also need to call the functions to send the empty date into the subform.
The code in the function of the subform must be something like this:
IF IdatTheDateFromTheHeader = 0D THEN
SETRANGE("Some Date") // this will remove the filter
ELSE
SETRANGE("Some Date",IdatTheDateFromTheHeader);
CurrForm.UPDATE(FALSE);
Regards,Alain Krikilion No PM,please use the forum. || May the <SOLVED>-attribute be in your title!
I don't have problem with boolean type flowfilters. Have you checked your flowfield? (it must include boolean type flowfilter) If ok, then maybe you can try a calcfields.
Edit: Sorry, you say that TE, IPE field is normal. But flowfilters are used to filter flowfields. So you can make some modification like changing your field type to flowfield or you can filter your field by a variable.
Comments
Pargesoft
GD
Then you can create a function in the subform like SetDateFilter which gets DateFilter as parameter. On the mainform call SubForm's SetDateFilter function on OnValidate and use a CurrForm.UPDATE on OnAfterValidate.
If not clear, I can send you an example object.
Pargesoft
GD
GD
The code in the function of the subform must be something like this:
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!
This works when the fields are of date but if they are boolean it doesnt work for eg
when i set the subformlink property as below:
TE FIELD TE FILTER
IPE FIELD IPE FILTER
TE,IPE Datatype Bool,fieldclass :Normal
TE Filter,IPE Filter Datatype bool,fieldclass :Flowfilter
thanks kriki,ufuk
GD
Edit: Sorry, you say that TE, IPE field is normal. But flowfilters are used to filter flowfields. So you can make some modification like changing your field type to flowfield or you can filter your field by a variable.
Pargesoft