Find a value and navigate to that field

[jgelpi16]

I have a continuous form that users will be selecting specific rows using a check box. I need the form to requery after each checkbox is selected. When I do this, obviously the form resets the focus to the first field in the "table". How do I "find" the row the user just selected so I can navigate back to that specific row for the user once the form has requeried? I have a PrizeID field which is a unique identifier.

[RuralGuy]

Why do you feel you need to Requery after the user checks a Checkbox?

[jgelpi16]

You know what....After reviewing my code (This is a DB I haven't looked at in a year) it appears I don't need to requery...Thanks for asking the simple question!

For future reference is there an easy way to do what I was looking to do?

[RuralGuy]

On a Continuous Form? Here's a link and I'll let you decide: http://www.lebans.com/setgetsb.htm