Thanks for the reply. I got a really good solution to this.

Appreciate your help.

The idea is to use ms access accdb file as front end rather than adp

Gives lots of flexibility.

Working on it right now. I never been to a computer class so it's all trial and error.

If you would like to know what the solution is, I can post it...I sure other people would want to know about it too.