Brendan Reynolds wrote:
Well, you've got my curiositly going now! So I tried changing the code
behind the command button as follows, (I've left the original ADO
code in there, but commented out) and sure enough the error
disappears ...

Brendan, I just tried your code and still get runtime error 3021! Replacing
ADO code with CurrentDb.Execute calls doesn't help me. Which Access version
do you use and which references did you set?

Boris

[...]