A novice here.
I created a db for info on hospital patients. The Primary Key (no duplicates)is an ID number assigned by the hosptial, and is therefore not auto-created by Access. My goal is for the patientID field on the data input form - on enter - scan the DB for the ID, and if already...