I have an Access 2k database with a VB6 front end, I have retrieved the data I require to each of the forms using ADO data control with Data Grid display. Whilst creating the database I have set the primary key as an auto number, the trouble is I also require a field containing the current date and the two can't be combined for more than 1 record. I can change the autonumber to number but I need to add/remove records. As all I have to do to add a record is enter it into the Data Grid, can I maintain this by creating my own autonumber that will allow dates? How do I create my own autonumber without duplicates. Thanking you Regards M

I located this: http://www.simply-access.com/SimplyAccess_Tips-Manual-Auto-Number-Microsoft-Access.html but has anybody any idea as to how I implement this with my ADO data control database connection? Or is there a simpler way? Regards M