Autonumber

[imright]

I'm autonumbering my form by going into the properties Default Value and entering the following" DLast("[ID]","ICAR_Table")+1. It works fine in my form until I start moving the input boxes into a usable form format. Doesn't make sense to me why it would work until that happens. Any ideas why it is doing that?
Is there another way to autonumber besides the autonumber provided? I need to start at a number such as 1393 so autonumbering wouldn't work for me, would it?

 

[missinglinq]

I suspect it's only coincidental that the problem is occurring now. Form Access Help:

You can use the DFirst and DLast functions to return a random record from a particu"lar field in a table or query when you simply need any value from that field"

Replace the DLast() function with the DMax() funvtion and your code should work just fine!

 

[imright]

It worked, thanks

 

[missinglinq]

Glad you got it working!