Thanks Jono, I did eventually get that to work using your code from a different post. not sure what the difference was now because I have read so many different posts and I am now very confused.

I have copied and pasted this exactly as it is here, I have named my target field DESC and I can't get it to work. I have pasted it into a change event on the first drop down box and then I tried it on the target drop down box. Can you please tell me what I am missing? I have read heaps of posts and...