removing auto number numbers

[Dave31]

Hi there

I believe what i want to do is fairly tricky. I have a defect form where the user can enter in defects and click 'ok' to save the record and goes to the next free record for another defect to be entered, while an auto number is generated for the ID. You can also cancel out which wont save the current defect unless you have 'Ok'ed it.
As soon as you enter detials for one field, it generates the auto number. Now, if you select 'Cancel' so the defect isnt saved, you will exit out of that form, but the auto number will still increament up, which will give an unregular increments.
That might sound a little confusing, so ill try and give an example:

you enter in your first defect, the auto number gives it '1', you fill in the rest of the fields and click 'Ok', this saves the record and goes to the next free record for the next defect. Fill in the half the fields (so the auto number generates the number '2'), but you decide not to enter that defect, so you click 'cancel' (closing the form and not saving it)
Now, if you go back to the defects form and go to enter in another new defect, the next auto number generates the number '3' and you save it
So now you have 2 records, but it looks like theres 3 as the auto number indicates there are 3 records (records 1 and 3) but really there are only 2 records
Now my question is, can you get round this? can you have it so it will never miss a number in the increments if you cancel a record?

Remember that this will always be the last record in the table you are deleting, so the next record will be empty.

let me know if you still need an better explanation, ill try and help. Sorry for such a long post

Thanks in advance

 

[KeithG]

What you want is an unbound form them. As soon as you enter info onto the bound form the autonumber will be generated. What you want to do is add code to your okay button to insert the record from your unbound form. You can either do this with a recordset or SQL.