Hello,

Im not sure if this can be done or not but i'm sure it can. What i'm trying to do is assign control numbers to my forms programically. What I would like to do is have a table that contains control numbers in my database and create a module and on button click assign control numbers to all forms and update my tables, but the the control numbers can only be used once..so basically I would like the module to check the control numbers table and see which control numbers have been assign and increment the control numbers as more data is appended. For example:

Say I appended 10 new records into a blank database and my control number table as of right now is empty. I would like to on button click start assigning control numbers to those 10 new records, but also at the same time update the control numbers table with those control numbers, and then when i append again say another 10 records and I hit that button again it will check that control numbers table and see that there have already been 10 control numbers assigned already and just increment that number based on the number of records that just had been appended. Can this be done? Thanks for your help

Does this make any sense?

James