Update query works but not when called in a form

[agiuga]

Hi

I have a calculated field on a form and want to use it to update a field in a table. I have created an update query and when I run it it works taking the value from the open form.
When I try to run the query using the DoCmd.Openquery method it doesn't work. I have also tried execute query. No errors it is just the table isn't updated after the form field is updated. I have tried refreshing and requerying the form and control. Any ideas would be great.

I have added a button to run the query and it works. Why it doesn't as an event in the text box change event goodness knows.

[Micron]

this
the table isn't updated after the form field is updated
and this
as an event in the text box change event
are not supportive of each other. A form control isn't updated by the Change event. How are you executing the query from the form? What is the event and code for it?

[agiuga]

Thanks. Maybe it's a different event. I have a query which works and when the calculated field changes value on the form I want the query to run. I used DoCmd.OpenQuery "Overall Cost"
So where or which event would I add this too.

[aytee111]

At the same time that the field is being calculated - that would be a good time to update the table, when a new value appears in the textbox.

[Micron]

the after update event