CurrentDb.Execute Problem

[matt753]

I have the followind code executing when a popup form closes.

CurrentDb.Execute ("UPDATE Orders SET RequiredDate=#" & [ShippedDate] & "# WHERE OrderID=" & [OrderID] & ";")

I need the 'RequiredDate' field in the backend db to update to what is stored in the [RequiredDate] fireld. I also have the Shipped date updating in the db but that is done automatically since it is bound.

First I got the "Write conflict" errors, but once I fixed those, now it will work but only if I update the shipping info, close the form, open it again, then close it (it will work once the same shipping info is there, and the same after closing the subform twice)

[TheSmileyCoder]

You need to show us the rest of the code and the context in which it is being used. The code you have shown us should work fine, so there must be something your not telling us. Im guessing it involves requerying some information on your form, but you have to provide more details for us to help.