I need help on incrementing a field value by 1 automatically from a previous record, but have the ability to initialize to zero with the OnChange event. The scenario is inputting a beginning test # that increases by 1 for each job. When a job # changes, the test numbers will start over again. I've used DMAX("[Test #]", "tblMain") + 1 for incrementing, but can't get the code to re-initialize with each job change. Can someone please help me? TIA
