- Local time
- Today, 21:56
- Joined
- Jul 9, 2003
- Messages
- 16,282
I have an MS Access form linked to an MSSQL table via ODBC. When I create a new record on the Access form, the record ID remains blank, I know this is expected behaviour in MSSQL.
I need the record number (ID) of the newly created record for my VBA code.
I know there is a way of obtaining this number, but I can't find the method/code! The problem is I don't know what I'm looking for, in other words none of my searches have been successful hence the reason for me posting this question!
Any help, observations or criticism welcome.
Cheers Tony
I need the record number (ID) of the newly created record for my VBA code.
I know there is a way of obtaining this number, but I can't find the method/code! The problem is I don't know what I'm looking for, in other words none of my searches have been successful hence the reason for me posting this question!
Any help, observations or criticism welcome.
Cheers Tony