In main form, when ‘code’ is selected, corresponding records from JBL table are displayed in subform. If I use run-time filter by using filter button frm toolbar. How do I retrieve records which are filtered to add field values. How do I get run-time filter value? Thanks, Uday
Sorry, Don’t understand the question… plz give a exsample.
GETFILTER should do the trick
quote:
Originally posted by Uday: In main form, when ‘code’ is selected, corresponding records from JBL table are displayed in subform. If I use run-time filter by using filter button frm toolbar. How do I retrieve records which are filtered to add field values. How do I get run-time filter value? Thanks, Uday
My apology, I should give an example. Here is the problem. I have two tables, Environment Class and JBL. I am displaying records from JBL and adding values of Amount field for all the records displayed, for corresponding Environment Code chosen from Environment Class. Now, when I use filter button frm Toolbar to filter JBL table, How do I know, which field is used for filter during run-time. so, I can update my total for the Amount field. hope this will clear my problem. hi! Hannes, I have tried GETFILTER and it doesnt say anything which field is used as filter, when I make use of filter button frm Toolbar. Thanks, Uday
GETFILTERS shows all filters. With best regards from Switzerland Marcus Fabian