Set Focus of a form

MonkeyMan666 · March 5th, 2009, 06:36 AM

Hiya,

I am having a problem with the SetFocus function on a form using Access 2003 in a .adp file.

I have a list of fields, some of which require the user to scroll down the screen to see them. When one of these is updated a stored procedure is fired to update the cumulative totals and the form is requeried. In order for the user to go to the next relevant field I set the focus to that control but when the form is refreshed it scrolls back to the top.

The focus is being set correctly but it is the window scrolling to the top which is the issue. Is there anyway to scroll the window back down so the user can see the control that has the focus.

The code for this is:

Code:

'Requery the form
Forms!frmDetailed.Requery
    
'Set the focus to ActualTotal
Me.ActualTotal.SetFocus

Thanks in advance

MonkeyMan666 · March 5th, 2009, 09:32 AM

I fixed it, the problem was I was requerying the main form not the subform, changed this and it works fine.

Thanks