updateing a value in text box baseed on a value in popupform

[mohammadagul]

Hi,

I have a small problem here ..

What I have is a An invoice form with a field Called FreightCharges. Now freight Charges can be more than one. So I made another table by the name of FreightCharges with the following field

Invoiceno
Type of Charges
Anmount
Total

I made a continuous form based on the above mentioned fields.

In my invoice form I had placed a button next to freightcharges texbox. When the user click the button the continuouls popup form open for entering the Details.

What I want now is to have the total of all the feight charges in my FreightCharge text box in invoice form.

Presently I am tryint to use the setvalue through macro.. but it is not accespting?

Can anyone tell mehow to do this.

 

[mohammadagul]

hi
Any Suggestions.

 

[mohammadagul]

Please friend, give me something to work with.. i really need to have this done today.

 

[Kodama76]

Not sure if you are still trying to solve this but here's a hint or two.

In the sub form create a field that sums up all of the charges.

In the main form create a text box that references that field. It'll be something like Forms![subform]![ChargesSum] ....If I were you I'd run the expression builder on that field indtead of trusting my memory and choose your subform and field that way so as to avoid typos.

Good Luck