Custom auto number

[Guest]

I want to have an auto number that goes off of the date and also adds a
number eather before it of after it...EX. 05-0001..05 being the year and 0001
being the number for that year. I will need this to change from year to
year.Thanks Dueyx

 

[Rick Brandt]

I want to have an auto number that goes off of the date and also adds
a number eather before it of after it...EX. 05-0001..05 being the
year and 0001 being the number for that year. I will need this to
change from year to year.Thanks Dueyx

*Store* as two separate fields RecordDate and RecordID. In the BeforeUpdate
event of the form used to insert rcords have code...

If IsNull(Me.RecordID) = True Then
Me.RecordID = Nz(DMax("RecordID", "TableName", "Year(RecordDate) =
Year(Date)"), 0) + 1
End If

*Display* using the expression...

Format(RecordDate,"yy-") & Format(RecordID, "0000")