Hi Mark,Originally Posted by GTO
That's worked perfectly. Thanks very much mate.
Just two other things that I could do with some help with.
1. When more than one user is using the form, if they click on OK and Save at the same time, a conflict error comes up as the form tries to enter both sets of data into the same row. Any ideas how to solve this?
2. When a user opens the Form, I'd like Excel to minimize so that the form will appear on screen and can be used without having to have Excel in the background.
Thanks again for all your help