Some thing instead of AutoNumber

[Fekri]

Hi,

In AutoNumber: in New record will make the "maxNo+1" for any fields.
It's good but if you use escape to forget the current record you can not use that number again and will lost forever.
Is there any way to make (MaxDocNo+1) for any fields as default value when user want to make new record?

Thanks
Ali

 

[PHV]

Have a look here: faq700-184

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Fekri]

THanks,

I think it's what I want.

but How I should use it in my textbox in form?

Ali

 

[Fekri]

I used this code but as I couldn't recognize this code,


Can you just tell me which words in this code to be replace by what?

thanks
Ali

 

[Fekri]

I tried by other way,

I made one query named by "MaxofResid Anbar" to find Max Number of DocNo and then in the property of the textbox inform:

1) Control Source:[DocNo]
2) Default Value: =[MaxofResid Anbar]![MaxOfResid Anbar No]

But still not success to get value

Can you help by this way?

Thanks
Ali