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...
Hi Experts
MS Access is not my forte but have used it to complete a couple of projects in the past (Access 97 and 2003). I am developing this one using MS Access 2007.
I am using the BeforeInsert Event on my Form to automatically increment the primary key field as the user clicks into the...