Record ID

Hi,
The easiest way is to make the field an 'Autonumber' type (in Access, or whatever the corresponding type is for your db). Then make sure that this field is NOT included on the 'add' form, and the numbers increment automatically.

Thanks Pete
It didnt work when I just hid it (DUH)( <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=3412&image=1&table=forumreplies' class='bbcemoticon' alt='<<' /> ). It did work when I removed it from the page.

Hi, I downloaded the trial version and I'm using it on an existing database. I need to know if there is a way of reading the values and incrementing them by one. I can not do it with access because the database isn't designed that way. Can anybody help?
Thanks,

Brian

Brian,
you can do something like select max(id)+1 as newid right before inserting a new record.