Your email :
<hr>Thanks for your advice. I am really new at Access. I can find a 'Before Update' field but not a 'Before Insert' field. When I type the code into VB, it highlights the word 'then' and gives me a message Expected: end of statement. I am also new to the Lounge and couldn't figure out how to add a thread to my original message. 1- To answer to a post in the lounge, just clik on the icon marked 1 in the picture.
2- It is the Berore insert of the form you have to use. To select the form, click on the square in the circle marked 2 on the picture. Then select the before insert event.
3- For the "then" error I suspect a typo error. Check the spell or use copy and past to enter the code.
Sorry for the messy picture, but I want to use one picture for the two applications