Writing back to table

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kevin - 09 May 2007 01:30 GMT

I have a Form that gets infomation from a table via a query. What i need to
do is after i complete a caculation, i need to write the revised value back
to the original table. I need to writ it as these items change a lot and it
keeps my data live.

The code i use to caculate the new quantityinstock in the materials subform
is
Private Sub QTY_Exit(Cancel As Integer)
Me.tempqty = Me.Quantityinstock - Me.QTY
Quantityinstock = Me.tempqty
Me.tempqty = 0
End Sub

What i need to do is write the quantityinstock to the "stock" table, using
the predefined part number. Can someone help me with this.

Signature

Many Thanks
Kevin

Reply to this Message

ruralguy - 09 May 2007 06:49 GMT

Does the following link suggest an alternate approach to your problem?
http://allenbrowne.com/AppInventory.html

>I have a Form that gets infomation from a table via a query. What i need to
>do is after i complete a caculation, i need to write the revised value back
[quoted text clipped - 11 lines]
>What i need to do is write the quantityinstock to the "stock" table, using
>the predefined part number. Can someone help me with this.

Signature

HTH - RuralGuy (RG for short) acXP WinXP Pro
Please post back to this forum so all may benefit.

Reply to this Message