Hi VbaInet
Thanks.
1. I have put DMax() code in the Default Value property of the textbox. (fyi - The textbox is a primary key). This seems to be working well.
2. I have kept the code in the form before update event
However, I cannot seem to edit the information on the subform (just 1...