Add sub form in Report to calculate (discount, Travel allowance...)

[Zinger]

Hi everyone! I am a newbie in MS ACCESS. So let me explain it in baby steps.
I have 3 forms:

First form describes client information (Which has> ClientID, name, address...)
Second form describes service information (Which has> ServiceID, TypeofServices, price, quantity, Subtotal, ClientID)

Third form describes RateForm (Which has> RateID, Date, Discount, consumptiontax, travelallowance, ClientID)

i create form and subforms which looks pretty. I would like to create an invoice report based on this 3 forms. The problem start to third forms. So how can i get those values in invoice report which is coming from third form and perform the operation linked in Second form?

I want my invoice report to do these operations.

SUBTOTAL = $ 1000
Consumption Tax = 1%
travel allowance = 7%
Discount = 8%

TOTAL TO PAY = $ 1000

i tried inputBox to insert manual in report. it worked but when i click to preview no value was showing. I even tried to use sql function to select from table Rate_tb nothing worked. Any suggest is welcome

 

[llkhoutx]

Add a subform with the desired calculated fields, calculating the datasource of each on some form event.

One cannot use the subform_onload event because the subform with be loaded before the data in the main form. Try on the subform_oncurrent event, which may or may not work.