Thank you Alex. I appreciate your suggestions but I would rather not have my users waiting until they have entered all data before finding out that they have a duplicate order number.

I would really like to find out why the code works when the workorderf is opened on its own but not when other forms are open. Could it be because there is a me.undo on duplicate entry? As you know the code is in the beforeupdate event on the ordernumber field and is a private sub. Should it also be placed somewhere else?

Also, after creating an order through the unitf, which is the last form in the process, is there a way to close all preceding forms without clicking close on each individual form?

After having now completed the whole seminar, this is the only issue I have not been able to resolve.

I have thoroughly enjoyed the whole learning experience and would highly recommend it to anyone who wishes to learn more about Microsoft Access. I now need to be able to split my database, can you suggest which course would be best?

Thanks again for all your help.

Kind regards
Anne

---

Reply from Alex Hedley:

I'll have to test it when I'm back on a PC.

You could have a list of commands closing each form:
DoCmd.Close acForm, "FORMNAME", acSaveYes

There is either the Split DB Seminar or the Security Seminar.