copy field data to a socond field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
Back
Top