Jack Michaelson — Fri, 31 Mar 2000 09:43:00 +0000

Solved it myself already,

Thanx anyway.

Peter J. Boettcher — Thu, 30 Mar 2000 16:04:00 +0000

Jack,

Looks like you're missing an "'", try this:

rs2.Open "Delete from orders where idnr='"&deleted&"'", Conn, adOpenDynamic, 4

Plus it's just my personal preference but I like to put spaces inbetween like this:

idnr = '" & deleted & "'"

It makes the code easier to read and debug.

Regards,
Peter J. Boettcher

lamandais — Thu, 30 Mar 2000 15:34:00 +0000

try out
rs2.Open "Delete from orders where idnr="&deleted&", Conn, adOpenDynamic, 4