I have an access database which I am trying to change to update a sql database. On one of the forms there is a function
DoCmd.GoToRecord, , acNewRecord
When the linked table is pointing to an access table this works when I change the linked table to point to a sql table it fails.
thanks for your help.