Assign the value of a caculated control to another control

J

jessica

Hello all,

I have a inventory control database here. For the products, on the products
detail form, "UnitsOnOrder" and "UnitsOnHand" is two caculated control based
on the invertory transaction history.

because I have another Read only products form to allow users only view the
information. and I do not want to caculate the values every time to load the
readonly form. So that I want to assign those two caculated value to another
two corresponding control(related to some column) on products form when the
caculation is done.

I have tried to use the "AfterUpdate" "OnChange" event of the caculated
control to setvalue to the destination controls, but looks like none of
events was not triggered becuase of the caculated control.

Any solutions? Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top