>I have a table with fields userid, username and userfullname. I have created a form to add new technician to the table. How can I increment my userid when I add new technician to my table? Please help. Thanks, Sam

The easiest way is to use Integer(AutoIncrement) field type.