Expand|Select|Wrap|Line Numbers
- CurrentDb.Execute ("UPDATE Orders SET RequiredDate=#" & [ShippedDate] & "# WHERE OrderID=" & [OrderID] & ";")
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)