Thanks for the good advice, I like ripping other Databases apart to understand what made each item tick.

I have decided to re write the whole macro and this time there was no Identifier error for status, Strange it now seems to work.

Saying that, Whilst testing I have tried to force the latter part of the macro to produce the on hold error message and I'm either setting the tables up wrong to make it fail or the macro does not work?



Who knows? I will plough on.

Thanks

Again