Dmax Help with unique numbers

[baronqueefington]

Good evening,

I have been reading up on unique numbers this evening, especially for split databases and there are a many threads on using Dmax+1.

I have given it a try and cannot get the field I want to auto +1 when I create a new record.

I have placed this code =DMax("[DOLS#]","[DolsDataTable]")+1 in the 'before update' for the form but the next record always shows '0'

I have provided a stripped down version of my database via onedrive.

http://1drv.ms/1B0hAH4



Any advice would be much appreciated.

[June7]

I can't download from Onedrive now and if the file is very large, not from home later.

If you attach to post I can download. Follow instructions at bottom of my post.

[baronqueefington]

Will do, the file includes 1 table and 1form with 2 fields and no data and only the code I've shown above in the form event property.

[June7]

I tried your download link from home and it failed.

[baronqueefington]

Apologies for the slow reply, please find attached a zipped copy.

Thank you

[baronqueefington]

Hello again,

After doing some more reading I have now solved my issue. Thank you for your help.