auto increment id

I am developing a form that is linked to a single table. I am using an auto increment field as the record ID the users are given to identify their record. If 2 users open the form at the same time, they are given the same ID number. When the first user saves, they will keep the number...

I am really hoping someone can help me. I am a complete noob to VB 2008 though I have worked with MS Access, VBA and VB for 15 years. I have been asked to write a system for employee to enter expenses. I’ve setup 2 tables in SQL, first the ExpenseHdr for employee, date etc… then ExpenseLines...