Scrolling subform

  • Thread starter Thread starter Max Moor
  • Start date Start date
M

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
 
Me!fsubMySubForm.Form.Recordset.FindFirst "[FieldName]=Value"
Click to expand...


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
 
Back
Top