Hello there,

Controls("heb" & G_Grid).SetFocus

This line woked ok on access 2003. Now in access 2007 it comes with an error can't move focus.

Any Idea how to get over this problem?

Thanks

I would use

Me.Controls("heb" & G_Grid).SetFocus

And sometimes you might need to concatenate first:

Dim strCtl As String

strCtl = "heb" & G_Grid

Me.Controls(strCtl).SetFocus

__________________
Thanks,

Bob Larson
Access MVP (2008-2010, 2011)
Free Access tutorials, samples, tools