Greetings,

In short: I have a Main Form and a Sub Form. The Main Form contains a Top 5 by count and the Sub Form contains the details for each record that makes up the Top 5. When I click or activate one of the items in the Main Form Top 5, I need the Sub Form to automatically scroll to it's relevant set of items (first in group). See attached.

The rest of the story:
Why not just scroll down manually? Hey, it's what the boss wants.

Both forms are based on queries. I've attached a zip with an Excel sheet in it with a screen image and SQL for the queries. The forms are in datasheet view only and I must use them in that view only.

I have NO idea where to begin. All I can guess is I need some code at "On Enter" or "On Got Focus" at the text boxes on the MainForm. I have blacked out non relevant items on my attached example due to privacy and Proprietary rules I must follow.

I appreciate the help.

Thanks,
David

Attached Files

AutoScroll.zip (109.7 KB, 2 views)