Hi macropod I'm required to do it the hard way with code
Guessed I made the changes you suggested the code doesn't give me that error any more but now I get the following error:
Run Time error 91 Do you have anymore advice?? I have attach the word document with the changes and the access database as well. Thank you