I have tried a few different "on event" codes and cannot get my form to work the way I need it to. I have a few things going on but to simplify it I'm in need of an easy fix.
I have a main form "sfrm_customers" that has six fields displayed from the customer table I created (tbl_customers). I created a combo bx for customer name and an "add new record" button to my form.
CustomerID - Primary
CustomerName - no duplicates
AssignedSls
AssignedPrm
AssignedEva
AssignedPrc
The "assigned" fields are assigned leads for these clients in different departments.
My goal is to lock the customername field unless it's a new record being added. I do not want anyone modifying a customer name once the record has been created. CustomerID is locked at the base of the table by default since it's on autonumber and primary key.