Hello everyone
i have a form with a subform. in my form i have number which i want to be as a auto number but i dont want to use autonumber function.
The way i want this is to add a number every time when you add a new record but also be able to edit that the reason is because it start from 1000 so it will be something like 1000+1 and etc

Can any one tell me how to do this please?

Best Regards,
Hamed Gholamian

Hi Hamed,

Does something like the following help you?

=IIf(IsNull(DMax("[EntryNumber]","qryInputDataActive")+1),1,DMax("[EntryNumber]","qryInputDataActive")+1)



Clive Astley