Hi How we can get the value of no of records displayed in subform? My intention is to show this value in the main form. Regards Joseph Mathew
You could have a FlowField in the main form, with the method “count” on the table that is displayed in the subform.
Unfortunately the subform can not provide the main form with any information unless the main form asks for it by calling a function on the subform that returns the desired information. I would try to layout the forms so that the total is actually on the subform (although it may appear to the user as if it were on the main form). The problem with a FlowField on the main form is that it is not updated until the focus shifts from the subform back the main form. Also the definition of the FlowField is fixed and can not anticipate filters the user may set on the subform.