Jumping to row in Subform

[Vegard H. Villmones]

Hi!

Houston I have a problem. I'm using access 2003 and can't find out how to
jump / goto a certain row on a subform (from vb code). My form has thousands
of entries, and I want to jump to a certain row based on some search
criteria, or at least be able to jump to i.e. row nr xx (something). How do
I do this? Anyone?

Vegard

[Mike Storr]

If using DAO, then you could use the FindFirst method of the forms
recordsetclone, then set the fomrs bookmark to the clones bookmark.
Alternatively, try using DoCmd.GotoRecord while the subform has focus.

Mike Storr
www.veraccess.com
"Vegard H. Villmones" <vv******@c2i.net> wrote in message
news:f_******************@news4.e.nsc.no...

Hi!

Houston I have a problem. I'm using access 2003 and can't find out how to
jump / goto a certain row on a subform (from vb code). My form has thousands of entries, and I want to jump to a certain row based on some search
criteria, or at least be able to jump to i.e. row nr xx (something). How do I do this? Anyone?

Vegard