Auto Increment Number on Subform

[Irshad Alam]

I want to obtain auto increment number on my subform.

For example : Please find the below :

Table Name : Table1
FormNo (Numeric Type), NameEmp, CodeEmp, Adds

Table Name : Table2
FormNo, DoNos (numeric type), Descrp, Chgs

I created one to many relationship with "FormNo" field.

Made the Form, where Main Form is "Form1" and the subform
is "Form2"

Now I want to obtain autoincrement number on Subform
field "DoNos".

Please help me, how to write the code for this, where to
adjust the code and how to run it.

 

[Douglas J. Steele]

Change the data type for DoNos in the table from Numeric to AutoNumber.
Forms don't really enter into the picture.