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