soloprogrammer
New member
- Local time
- Today, 16:20
- Joined
- Sep 13, 2002
- Messages
- 7
I recently converted a Microsoft Access97 application to Microsoft Access 2000 with a SQL Server backend.
There were Previous and Next buttons, but when I want to go to different records, I get a "Can't go to specified record" error.
In testing this worked BEFORE I moved the tables to SQL Server Backend. The first form has a search on it. When you find the record you want, you double click on it, which fires the following code:
DoCmd.OpenForm "DataInputForm", acNormal, ,,,, Me.ListBoxSearchResults
--Like I said before, this part worked, until I moved the data over to SQL Server backend.
When I converted it to SQL Server backend, I had to change the code because it was always going to the first record instead of the specific searched record. So I modified the code to:
DoCmd.OpenForm "DataInputForm", acNormal, , "primary = " & Me.ListBoxSearchResults.Column(0),,, Me.ListBoxSearchResults
Now I get the "Can't go to Specified Record" error.
Any Help would be great!
There were Previous and Next buttons, but when I want to go to different records, I get a "Can't go to specified record" error.
In testing this worked BEFORE I moved the tables to SQL Server Backend. The first form has a search on it. When you find the record you want, you double click on it, which fires the following code:
DoCmd.OpenForm "DataInputForm", acNormal, ,,,, Me.ListBoxSearchResults
--Like I said before, this part worked, until I moved the data over to SQL Server backend.
When I converted it to SQL Server backend, I had to change the code because it was always going to the first record instead of the specific searched record. So I modified the code to:
DoCmd.OpenForm "DataInputForm", acNormal, , "primary = " & Me.ListBoxSearchResults.Column(0),,, Me.ListBoxSearchResults
Now I get the "Can't go to Specified Record" error.
Any Help would be great!
