Sorry for the delay in replying, I've been away.

Thanks for your answer.
The DAO vs ADO has been an area which has had me stumped on numerous occasions.
I think after reading quite a bit on this topic that I am finally strting to understand why I need to use ADO in this instance.
It means quite a change to how I am constructing this type of form, and I'm in the process of re-creating forms which will use ADO.

I suppose I'm still too early in the process to continue to ask questions in this thread, now that I've started to base this on ADO, but will come back to it once I get a little further down the track.

Thanks again for you reply.

Dave