for a bit more back ground.
I'm nearly ther but not quite:
Form is bound to a View(joining three tables) with unique table set.
User hits custom "New" button.
User fills prompts for fields that are part of FK relationships.
.recordset.addnew method called.
Above data is applied to bound controls.
.recordset.update method is called.
Form is left waiting for user to complete other, non-required, info.
If I check in the SQL Server at this stage I see the new record with above info PLUS defaults that are set in the server.
However the record on the form doesn't reflect these defaults and it doesn't contain information that is calculated on the form OR fields that are calculated in the View.
e.g. check boxes on the form that default to no/off are shown as null.
... controls on the form with expressions such as "=Make + ' ' + Product are empty"
I have a "Done" button on the form including the code ...
If .Recordset.EOF <> True Then
If .Recordset.EditMode > 0 Then
The User adds extra info to bound controls then hits "Done".
However when the form moves to another record you get the old "Write Conflict" error box.
Then you get a bunch of "trouble access the OLE blah" and "cannot locate the record blah"
Things are a little better if no extra data is added to the form but it never updates this record with the data from the Server unless you do a menu>refresh. Then this causes more errors which I won't detail here. ho hum.