Simple maths

[EMILYTAN via AccessMonster.com]

I have this suform with this control InQty, OutQty, TotalQty (In- Out Qty)

Example of data

Iteml | InQty| OutQty| TotalQty

ABC 4 1 3
CDE 10 5 5

Since the value of the InQty will be loaded in from excel, so when I open the
subform, I would like to generate all the total quantity all when loaded.

All controls are bound....
However, I tried to put in form load, but it can only work for the first
record.

Any help?

 

[Guest]

Put it in OnCurrent event.

Steve

 

[EMILYTAN via AccessMonster.com]

You mean put in form on Current?
If that is the case, I have tried it before, it can only work when the user
select to the current record.
Isn't a bit troublesome, only get to see the result when the user select the
current record especially my case is, the data is loaded in?
Is there any way, is will calculated once the form is being loaded?

Put it in OnCurrent event.

Steve

I have this suform with this control InQty, OutQty, TotalQty (In- Out Qty)

[quoted text clipped - 13 lines]

Any help?

 

[Naeem Azizian]

You mean put in form on Current?
If that is the case, I have tried it before, it can only work when the user
select to the current record.
Isn't a bit troublesome, only get to see the result when the user select the
current record especially my case is, the data is loaded in?
Is there any way, is will calculated once the form is being loaded?

Put it in OnCurrent event.

[quoted text clipped - 13 lines]

Any help?

Put it in the On Load and if that still doesn't help delay it further
by putting it on the on activate

 

[Marshall Barton]

I have this suform with this control InQty, OutQty, TotalQty (In- Out Qty)

Example of data

Iteml | InQty| OutQty| TotalQty

ABC 4 1 3
CDE 10 5 5

Since the value of the InQty will be loaded in from excel, so when I open the
subform, I would like to generate all the total quantity all when loaded.

All controls are bound....
However, I tried to put in form load, but it can only work for the first
record.

Try putting the calculation in the subform's record source
query.

 

[EMILYTAN via AccessMonster.com]

Because I am doing calculations using DLookUp, so its better to do it using
VBA...

I have this suform with this control InQty, OutQty, TotalQty (In- Out Qty)

[quoted text clipped - 11 lines]

However, I tried to put in form load, but it can only work for the first
record.

Try putting the calculation in the subform's record source
query.

 

[EMILYTAN via AccessMonster.com]

Because I am doing calculations using DLookUp, so its better to do it using
VBA...

I have this suform with this control InQty, OutQty, TotalQty (In- Out Qty)

[quoted text clipped - 11 lines]

However, I tried to put in form load, but it can only work for the first
record.

Try putting the calculation in the subform's record source
query.

 

[EMILYTAN via AccessMonster.com]

Because I am doing calculations using DLookUp, so its better to do it using
VBA...

I have this suform with this control InQty, OutQty, TotalQty (In- Out Qty)

[quoted text clipped - 11 lines]

However, I tried to put in form load, but it can only work for the first
record.

Try putting the calculation in the subform's record source
query.