-
Okey dokey,
clunietp was kind enough to respond last time I posted with this darn
'3426 :Action was cancelled by an associated object' error
He (and others) suggested not using a data control where the AddNew was causing the error.
So I have rewritten the code to use a 'Append Query' and it works.
Now how do I make the data control show the new record ?
... I have tried datOrders.Refresh ... no go
... I have tried setting the .Recordsource to "" and then refreshing, then resetting the .Recordsource property ... but thats no go either.
How do you do it.
Cheers Dave
-
have you tried using .movelast .movefirst to populate the recordset
or go to your particular record using .findfirst or .bookmark=lastmodified?