Solution What's Up with this #Deleted Thing

[Alan Parker]

Using the time stamp option will not work if many records are appended to a table because the field will not be unique..


Here is a simple solution in access that is pretty generic so you can use it in all the input forms where fresh data is added.

I have assumed that the autonumber field is called Alan , just adjust this as neccessary for each form



On the Forms before insert event use.........
Alan = DMax("[Alan]", Me.RecordSource) + 1


Note the form recordsource has to be a table or query NOT a Select statement. If it is a select statement save the select statement as a query .. dead simple..


Hope this helps..