APPEND BLANK or SQL INSERT command. The record pointer will be sitting on the newly inserted record.

>My tables all have auto-increment turned on.
>
>When the user clicks the New Record button on the screen, normally I
>would do
>
>

>nNewId = GetNewPrimaryKey()
>INSERT INTO MyTable (Id) VALUES (nNewId)
>

>
>All other fields on the record are data entry fields and could be optional.
>
>So what do you insert to add a new record when using auto-increment?
>
>And, how do you know what the Id was that was auto-added?
>
>Thanks
>
>Kevin