copy field data to a socond field

K

Kevin

Can anyone point me in the right direction. I have a table that has 2 fields,
the first field is "QTYInStock" and the second field is "StockTakeQTY". What
i want to do is on "Exit" from the form, copy the "StockTakeQTY" to the
"QTYInStock" field and zero the "StockTakeQTY".

Any help would be very much appreciated.
 
D

Damian S

Hi Kevin,

Ignoring the fact that it sounds like your design is incorrect, you could
achieve what you have asked as follows:

In the form Close event, have the following code:

me.QTYInStock = me.StockTakeQTY
me.StockTakeQTY = 0

Hope this helps.

Damian.
 
Top