Hi All,
1. I have a form that is used to add new records to the existing table. I have a field called N_NUMBER which has unique numbers for each existing record and it is not of type autonumber. Now, that I want to add new record, I want the N_NUMBER field to display automatically the next number((max(N_NUMBER)+1)) and so forth for each new record I add.
2. Now that I am adding new records incase I want to duplicate the record through the form, how can I duplicate the records with unique N_NUMBER generation for each duplicate record.
Can someone please tell me how to do these step by step as I am new to Access.
Please help me!!
Thanks
1. I have a form that is used to add new records to the existing table. I have a field called N_NUMBER which has unique numbers for each existing record and it is not of type autonumber. Now, that I want to add new record, I want the N_NUMBER field to display automatically the next number((max(N_NUMBER)+1)) and so forth for each new record I add.
2. Now that I am adding new records incase I want to duplicate the record through the form, how can I duplicate the records with unique N_NUMBER generation for each duplicate record.
Can someone please tell me how to do these step by step as I am new to Access.
Please help me!!
Thanks