get max srno base on date

[waqas]

dear all,
i have a form in which i enter leaves with from and to date.

now i want to generate auto serial no base on from date.

for example i am updating 01-nov leave and total 10 id number's leaves in 01-nov i have updated it means max srno is 10 in date 01-Nov.



now i have update 02-nov leaves for 5 id numbers
in date 02 max srno should be 5.

now if i update for 01-nov it should start from max srno 11.



how can i do during live updating leaves on form

[June7]

This will require VBA code and can be complicated, especially as you have multiple series. Why do you need to do this?

[waqas]

thanks

i need this due to we update different types of leaves and then archive these papers this srno will help to make document number which we will put on document and base on this srno it will go into file.

to find this paper base on document no it will be easy in future.

can you explain vba code?

[June7]

I can offer you example code I use to generate a unique identifier. In my case there is only one series that starts over each year. Review this thread http://forums.aspfree.com/microsoft-...ta-403208.html

I recommend easier alternative is to use the Autonumber field to generate a unique ID for each record. You can then format this field to look like anything you want. Take unique ID of 1 and you want to show it as ABC00001. This would be accomplished with an expression in the ControlSource property of textbox on form: "ABC" & Format([ID], "00000")