I have a form where I can create a new record in a table. I do this with a simple select. However, there is a problem. The primary key of the table is an auto value. How can I display the next higher primary key in the textbox for the primary key in the form. Otherwise there is always the error message "Record could not be set up because of key violation."