BullZip Home

if your autonumberfield is called "alan"

in the form before insert property use this event procedure

[alan]=dmax("[alan]",me.recordsource)+1




Thats it , job done..

the form must be based on a table or query though, not a select sttement..