Error: Cannot got to specified record. Access 2007 and SQL 2005

I have inherited an Access 2007 database that has been split so the
tables are on a SQL 2005 server.

The database consists of 3 tables and 3 forms. The main form that is
used reads and writes to all 3 tables. Data can be edited and deleted
OK but trying to add a new record throws an error saying, "You can't
go to the specified record"

The code for the new record button is an embedded macro with the
follow parameters:

OnError Next,
GoToRecord ,,New,
[MacroError]0 MsgBox =[MacroError].[Description],Yes,None,

Any advice would be greatly appreciated

Thanks,

Amy

On Thu, 12 Nov 2009 01:52:21 -0800 (PST), Amies
wrote:

What is the RecordSource of that form?
If you create a View on SQL Server with the same sqlstatement, can you
add a row to it?
I suspect there are some joins involved and adding data simply is not
possible with such complex sqlstatement. Simplify.

-Tom.
Microsoft Access MVP


I have inherited an Access 2007 database that has been split so the
tables are on a SQL 2005 server.

The database consists of 3 tables and 3 forms. The main form that is
used reads and writes to all 3 tables. Data can be edited and deleted
OK but trying to add a new record throws an error saying, "You can't
go to the specified record"

The code for the new record button is an embedded macro with the
follow parameters:

OnError Next,
GoToRecord ,,New,
[MacroError]0 MsgBox =[MacroError].[Description],Yes,None,

Any advice would be greatly appreciated

Thanks,

Amy