Auto Increment Number on Subform

  • Thread starter Thread starter Irshad Alam
  • Start date Start date
I

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.
 
Change the data type for DoNos in the table from Numeric to AutoNumber.
Forms don't really enter into the picture.
 
Back
Top