I have a standalone Database program that has a search function that is giving
me some trouble. If I delete a record and then perform a search for that same
record I get run time error 3426 - "The action was cancelled by an associated
object."

I initially assumed that it was because I didn't refresh the recordset after
deleting the record so I added code to perform a recordset refresh upon the
delete. I still get the same error message. Any ideas?

Thanks in advance for your help.

Ken Sturgeon

http://www.*-*-*.com/ ~fishhead

  > >
  > > I have a standalone Database program that has a search function that is giving
  > > me some trouble. If I delete a record and then perform a search for that same
  > > record I get run time error 3426 - "The action was cancelled by an associated
  > > object."
  > >

  > Try doing an Update on your Recordset after you delete the record. Might
  > help.

Umm, no. Either Refresh the recordsets including that record or
move off of the deleted record immediately. Doing an Update will
just cause more errors. Read the help on Delete, dammit.

--

WARNING: I cannot be held responsible for the above        They're   coming  to
because  my cats have  apparently  learned to type.        take me away, ha ha!