Thanks for everyones input. The problem was solved by logging onto a 2000 machine and changing the record source for the form property. On the 2000 machine it has DBO....

Thanks

my typing is wrong in this question and it does have a space in the code. I will try the other things you suggested.