>I have this line of code in my app:
>
>
>DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
>
>
>It fires the Save Record bar on the Records menu. The question is, if it's being inserted, how do I get the new PK? If it's an update, how do I know what record I'm on?
>
>Thanks
See
http://msdn.microsoft.com/en-us/library/aa140015.aspxSELECT @@IDENTITY (same as in SQL Server)
If it's not broken, fix it until it is.
My Blog