Autonumbering

[drrajnishpatel via AccessMonster.com]

respected MVPs,
i am creating a form for based on table named "MCQ Test Registration" it has
field named "RegistrationID" this is autonumber & "EventID" this is Year -A,
-B -C -D like 2008-A, 2008-B, 2008-C, 2008-D, in the form, these 2 fields are
put togather to produce unique Student like "2008-A-1001, 2008-A-1002", and
so on for first.The event id when selected should start a new numbering from
1001 for every new eventid selected from dropdown list in the form,please
help

 

[Jeanette Cunningham]

see it this helps http://www.mvps.org/access/tables/tbl0005.htm

Jeanette Cunningham

 

[Jeanette Cunningham]

also see if this helps
http://www.rogersaccesslibrary.com/download3.asp?SampleName=AutonumberProblem.mdb

Jeanette Cunningham

 

[Tony Toews [MVP]]

respected MVPs,

And two excellent answers from a non MVP whom I've noticed before.
So there are lots of folks out there who can and do help out.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[drrajnishpatel via AccessMonster.com]

Thanks friends , but this does not help me.....

please see this, first event is selection of the test series from droplist.
like 2008-A,,,, then this StudentID should be autogenerates by clubbing
EventID and RegdID togather, where regdid is not shown in the form but is
seen only in conjugation with eventid in the studentid to produce unique
student like "2008-A-1001" onwards