I have amended an examination databases main table "All_persons" to include all previous applicants/candidates to the tests so their info. doesn't need to be re-entered for future applications.
The secretary's just need to tick the "2005 Applicants", which is filtered in a query and feed to the "all_enquires" form which is used to update the info. and add new applicants.
We need a unique & incremental reference number for each 2005 Applicant. I can't just use an AutoNumber field in the main table as it will number non-2005 Applicants. I've also tried =Nz(DMax("[id]","All_persons"),0)+1 in an "id" field in the form which works for any new entries but not for previous applicants re-entering (as they already exist in the main table). Any thoughts?