i am using Access 2003 to create a form where i can fill out customer details and the jobs i carry out for them, i want my form to create a unique code in my "job number" field. i want the code to be the date then another number after that which increases by one every record e.g.

if i entered a record on september 12th 2012 i want the job number to be:

12091201

then the next record would be:...