Copying he value in a form to tale

[Eason67]

Having calculated a value on a form, I want to transfer this value to a table.




I have some code but not sure its correct. I entered this into the after update section of the box with the calculated field in it.
CurrentDb.Execute "INSERT INTO [tblBookings] (Total price) VALUES (" _
& Me!Total price & ")", dbFailOnError

????

[ranman256]

1. To prevent, dont put spaces in field names/text boxes, Use mixed case: TotalPrice

2. use brackets, not parenthesis: [Total price] VALUES (" & Me![Total price] & ")", dbFailOnError

3. you dont need ANY code, connect the form to the table, then just type in the TotalPrice box. The data goes in without any code.

[Eason67]

OK so I've tried this and it doesn't seem to work.

The calculated value works. It wont save to a table though. If I use an entered value it does no problem.

Anyone know how I can get round this?

[June7]

Usually a bad idea to save calculated data, especially aggregate data. However, since prices can change over time, there is justification for saving the unit price value. If this is a bound form, no need for SQL action. Simply:

Me!Price = Me.NameOfPriceControl

Now calculate total price when needed.