I am performing an insert into an access table where the primary key is set to auto increment.
When I insert a record, is there an easy way to grab the value created by the auto increment without having to go back in read the newly created record? I need the value to display a result such as: "Your information has been added. The record number assigned was 1000. We recommend you write this down for future reference". Troy
