PDA

Click to See Complete Forum and Search --> : 3426, SQL and Data Controls query ...


Lil Dave
Jan 22nd, 2000, 10:50 AM
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

pardede
Jan 24th, 2000, 07:12 AM
have you tried using .movelast .movefirst to populate the recordset
or go to your particular record using .findfirst or .bookmark=lastmodified?