Textbox calculated value to table

[usselite]

Hello,

I got a textbox in a form which does calculate for me. Calculation works fine but now I need to write it away in a table. I use access 2010 and I am aware that the function calculation exist. But my calculation uses multiple tables so that is not going to work I suppose.

The textbox with value is named = 'totaal_prijs' and it needs to be written away in the table 'Bestelling' and in field 'totaal_prijs'.



This didn't seem to work:

CurrentDb.Execute "UPDATE Bestelling SET (totaal_prijs) Values ('"& Me.totaal_prijs &"')"

or

Me!totaal_prijs = Me!Bestelling.Column(4)

All are applied at the after update from the Form.

Edit:
This code works 1/2 but it updates ALL records. How can I make it update only the record from the form which is opened. And that I don't need to use an button?

docmd.setwarnings false
docmd.runsql "UPDATE Bestelling SET Bestelling.totaal_prijs = " & Forms!Bestelling!totaal_prijs
docmd.setwarnings true

[Bob Fitz]

Are you sure about saving this value to a table. It is not normally considered to be good practice to save calculations. Usually better to do the calculation again when/wherever required in case the data used changes.

[June7]

Use a WHERE clause in the SQL statement.

If totaal_prijs is a field of the form's RecordSource, this should work

Me!totaal_prijs = Me.Bestelling.Column(4)

[usselite]

Yes Bob Fitz, I am sure.

Use a WHERE clause in the SQL statement.

If totaal_prijs is a field of the form's RecordSource, this should work

Me!totaal_prijs = Me.Bestelling.Column(4)

I have tried it again but it really doesn't want work somehow. It does not give me any error at all. I applied it at after update from the form and tried it on the textbox with the value.

[June7]

Want to provide project for analysis? Follow instructions at bottom of my post.

[TG_W]

Have you thought about using an update query that kicks off after closing the form and/or with a button?