Expression Count

[azhar2006]

Hello all
I have a main form and a subform inside. I want to execute this expression (=Count([fullname])) on the subform and I put it on the main form.
Thanks to all

 

[arnelgp]

add a Unbound Textbox (txtCount) to the Form Footer of your subform and add the following
as it's ControlSource:

=Count([fullname])


on them main form, you Refer the the Unbound textbox (txtCount) of the Subform:

=[SubformName].[Form]![txtCount]

 

[bob fitz]

Hello all
I have a main form and a subform inside. I want to execute this expression (=Count([fullname])) on the subform and I put it on the main form.
Thanks to all

Create a text box control in the footer section of the sub form and use your expression as its control source.
Create a text box control on the main form and use a reference to the text box on the sub form as the control source for that text box.

 

[azhar2006]

add a Unbound Textbox (txtCount) to the Form Footer of your subform and add the following
as it's ControlSource:

=Count([fullname])


on them main form, you Refer the the Unbound textbox (txtCount) of the Subform:

=[SubformName].[Form]![txtCount]

Thank you very much

arnelgp​

You are amazing. It worked out regularly