Populating a feild in Access from a Calculated date in a form

[kimgclark]

I am trying to get a date that calculate in the control source on a form to update a field in a table. The formula works but does not update the table.

This is what I am using: =DateSerial(Yea r([Start date]),Month([Start date]),Day([Start date])+([Duration]\24))

Any ideas?

[NeoPa]

You need to operate on a control that is bound to the relevant field in your table.

What do you have as the recordset for your form at the moment?