Auto Copy inbound control into 2nd inbound control

[smyeong]

Dear all,
I was wondering is there a way to copy ActualQTY into another StoreQTY field as negative value for whatever figure has been keyed in on my form?
For instance,

itemA RequestedQTY ActualQTY StoreQTY
ABC........... 10............ 8 ............ -8 .....

Meaning to say when i have entered 8 into ActualQTY, it automatically copy the ActualQTY into StoreQTY as -8

Hope this clear to you and help me out ....
Thanks,
YEONG

 

[RichO]

In the After Update event for ActualQTY, put in this code

Me.StoreQTY = -Me.ActualQTY

 

[smyeong]

Copy inbound control A into inbound control B

In the After Update event for ActualQTY, put in this code

Me.StoreQTY = -Me.ActualQTY

Thanks for ur post. Sorry it 's not what i want. i don't want to change the figure itself from the exact figure to negative. I want duplicate it into next field as negative value.

in fact i need that field in to do some calculation by having different departments. The StoreQTY is same as ActualQTY only different is it's - negative to indicate it's outgoing item in Store Depart likewise the ActualQTy is for Production Depart to indicate it's incoming item.
My problem is that i couldn't find a way to auto-copy the ActualQTY into StoreQTY. In fact, the StoreQTY should be hidden as well.