>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.aspx

SELECT @@IDENTITY (same as in SQL Server)