Copy Function

[NewfieSarah]

Hey what does anyone know anything about a copy function? I think it is vb code but I am not sure. what i am trying to do is to. create a id number using the last 2 digits of the year from the date, and adding a "-" and adding the last record number plus 1... SO I think I have the date things but I am not sure how to do the last record id number plus 1?? I was told it could be done with a copy, I am not sure. what ideas do you have about it??

thanks

 

[WayneRyan]

Sarah,

This is a comon topic, use the Search Facility here and look for "DMax".

In some of the threads, you'll see that it's reccommended that you keep
the year and number fields separate. You can easily put them together
with a query for forms/reports.

You can use the BeforeInsert event of your form to populate the year
and sequence field.

Wayne