To insert data into a field of data type Number, we use
"INSERT INTO table
VALUES(" & text1.text & "')"
What need to be used in order to replace text1.text, to insert into a field of data type "Auto Number" in order to Auto Increment using
VB and Access
Please, do not mind my English. I am a South African.