I just upsized a Access 2007 (accdb) and created linked tables to SQL 2005.
The form is databound to a query result of two joining tables. The form's
property sheet has Recordset Type = Dynaset, Fetch Defaults=Yes. The form
has an Add New button with embedded macro (GoToRecord , , new).
This worked fine before the upsizing. Now clicking the same button, I got
"You can't go to the specified record". I change the button On Click event
to an Event Procedure like the following. I still get the same error
(Runtime error 2046, 2015). Please help.


Private Sub Command91_Click()
DoCmd.GoToRecord acDataForm, "frmTransferForm", acNewRec
End Sub