Writing back to table

G

Guest

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.
 

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

Similar Threads

subtracting one field total from a second field 1
Copy date from a form to a different table 10
Macro to update a field 1
Unbound form writing back to table 6
How to export table from outlook into ms access table? 0
Form not writing field value back to table 3
Amending a number in 1 table with info from another table 2
writing records to a table 6

Top