AWehrstedt
Programmer
I created a database application using Access 2000. It was set up with an Access front-end, connecting to an Access backend. Everything was operating fine but my client wanted it upgrade to a SQL Server 7.0 backend for web-connectivity.
On one form, which uses a sub-form, when you click on the "Add" button you get the error "Cannot go to specified record". It adds the current record into the database, but when it executes the following line of code..it shows that error and all the fields display "#Name"
The code is very simple:
DoCmd.GoToRecord ,,acNewRec
The same code seems to work on the other forms, but not this one. I'm assuming it has to do with being a sub-form.
Any help?
On one form, which uses a sub-form, when you click on the "Add" button you get the error "Cannot go to specified record". It adds the current record into the database, but when it executes the following line of code..it shows that error and all the fields display "#Name"
The code is very simple:
DoCmd.GoToRecord ,,acNewRec
The same code seems to work on the other forms, but not this one. I'm assuming it has to do with being a sub-form.
Any help?
