Scrolling subform

[Max Moor]

Hi All,
I have a need to jump a subform to a given record (uniquely
identifiable by an index number). The best I've been able to do is to
scroll it by checking each record and using MoveNext using language like:

Me!fsubMySubForm.Form.Recordset.MoveNext

Everything was fine until I got a pile of records in the subform.
Scrolling takes a long time. At least, a much longer time than I'd like.

Can anyone give me a faster technique for accomplishing this?

- Max

 

[Wayne Morgan]

Me!fsubMySubForm.Form.Recordset.FindFirst "[FieldName]=Value"

 

[Max Moor]

Me!fsubMySubForm.Form.Recordset.FindFirst "[FieldName]=Value"

Yes! I feel a little dumb, now that I see it. I use MoveFirst, MoveNext,
and MoveLast all over the place. I know I've seen the help for FindFirst.
Thanks, Wayne.

- Max