In a code module within Access, I use a SQL statement to insert a new row in a table.
The table has an autonumber field as the primary key.
I need to retrieve the primary key from the newly appended row.
This is what I have:
DoCmd.OpenQuery "qapdTickets", , acReadOnly
'Find the autonumber field value for the newly appended row.
Any hints would be appreciated.