I am a good programmer, but this one stumps me!
I have a form with a continuous subform. The continuous subform
contains records of data and may reach a depth of 1000's of entities.
I have created a search button on my form and it does its job quite
well. It presents the user with an inputbox, prompting for the string
to search. Then the code returns with a record number of the record
which contains the string.
Here's the problem. I want the subform to display the found record
within the visible area (as if the user scrolled down to it) of the
subform.
By default, the continuous subform displays records 1-30. Let's say the
search button returns the number 500. How can I get my continuous
subform to display starting with record 500, 501, 502, etc.?
Good Luck?