Hi!

I have a Form with a Subform (continuous form) containing one bound text box for each field in the subform's underlying query.

On the Main form, I have a combo box which has code in the event AfterUpdate. When the combo box selection is changed, several procedures are executed that process data, followed by a REQUERY.

The biggest complaint from my users is following the requery process, Access changes the focus to the first record, first text box (field) instead of the record and field they were previously looking at.

How do you get Access to return focus to the [u]same record and text box</u> the user was previously looking at before the requery?

Thank you ahead of time!


--- Tom

__________________
--- Tom

After the REQUERY, you could use:

Screen.PreviousControl.SetFocus

Hope that helps.

-Shay Shepston