go to a specific record using ADO 1

[Weebairnes]

How do you move to a specific record using ADO commands?

The code from where I want to execute this is in a module (not behind the form).
I don't think that the recordset clone does me any good.
Seek is only supported with server-side cursors.
Find works great, but how do I make the current record on the form the same as the record I found?

I'm not sure I understand the gotorecord command.
DoCmd.GoToRecord acDataForm, frmMain, acGoTo, intRecord

I believe that this requires that I know which record# the record I want to goto is.

Any idears?

 

[zemp]

'DoCmd.GoToRecord ', looks like this is Access VBA. If it is you would be better off posting in forum705 or one of the other Access fora.

Take Care,

zemp

"If the grass looks greener... it's probably because there is more manure."

 

[Weebairnes]

Oh. Thanks for the tip. Would you mind pointing out the difference between this forum and the one you suggested?

Thank you.

 

[zemp]

This forum is for straight VB (VB5, VB6) when working with backend database issues. Many of the Access VBA built in commands do not exist in VB, therefore you will not get many Access tipsters looking at threads in this forum. Myself, I have not worked with Access for a couple of years so I am not up on it's exact syntax and specific issues.

Take Care,

zemp

"If the grass looks greener... it's probably because there is more manure."