stephenbruceburch
Technical User
I am using access as a front-end for an oracle 9i database. I want to have something similiar to an auto number for the id's of each of the tables. I created a query that looks up the highest id # and adds one to it. What I don't know how to do is have it automatically appear in the 'id' box on the form when it goes to a new record.