Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Who Me Too'd this topic

Level 1
Level 1

Dear All ,


I'm facing an issue and I dont know how to do without use Script .
Unfortunatly, I don't know how to build a SCRIPT into the form .
Here the purpose of my request :

I have to display an invoice.
at the bottom of each Master Page

If invoice has only one page , I need to display a subform (S1) with several data as total amount, VAt .... etc !!!!
in case of several page, the previous subform ( S1 ) is replaced by S2 to display only one information.
this information is corresponding to the subtotal of Amount red into the Design View (Table-DATA -KWERT ) into the main area. .

One page or last page : display S1

Subform S1 bottom MP.png

Intermediate pages : Display Subtotal calculated: ( Sum of each Amount read in the current page) :

   Subform S2 bottom MP.png

I think I have to do at least , 2 things:
First : create a var ( SubT_Calculate) , calculating the Sum of amount during reading of data of each row .
Second : check if I'm in last page or not.


in this case ( not in last page)  :

-  have to hide S1 using a script  ,

-  get Var'value calculated and Display it in S2   .


If this possible ?

If possible ,  could you help to find solution to fix this issue, please ?

thank you so much for all help you could provide me.

best regards,

Take Care of you and your Familly .

Best regards,




Who Me Too'd this topic