Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Other Forums
 MS Access
 row number

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-01-24 : 09:20:20
iwe muiser writes "i have a question about the rownumber in a table in microsoft access 2000

i have made a query thet selects certain people out of a table.. but i need the rownumber of the table to make the following line work:

DoCmd.GoToRecord acDataForm, "Leerlingen", acGoTo, recnr

"recnr" is in this case a variable that represets the rownumber

can you help me with this problem??

thanks,

Iwe Muiser"

Tigger
Yak Posting Veteran

85 Posts

Posted - 2002-01-24 : 14:58:34
Have you tried

DoCmd.FindRecord

Maybe that will do what you want ??

Go to Top of Page

Tigger
Yak Posting Veteran

85 Posts

Posted - 2002-01-24 : 15:00:03
I should have said try DoCmd.FindRecord instead of DoCmd.GoToRecord, not to find the row number ...


Go to Top of Page
   

- Advertisement -