Getting object with focus. 1

[SmokingCrater]

I don't think this hard but I can't remember an easy way to do it and the search isn't working for me. How can you obtain which object has the focus on a form? When i do a requery (refresh) of the screen I want the cursor to return to where it was before the refresh. I want to set Object o = the control that has the focus so after the refresh, the object can be returned the focus.

Thanks.

 

[gcole]

Try:

Me.Combo71.SetFocus

Combo71 is the name of my control. Me refers to the current form. Let me know if this helps.

 

[SmokingCrater]

gcole, that helps to set the focus. I'm looking to determine what the "combo71" portion is. I'm looking for a quick easy (and dynamic) way to determine what the control is that the focus must get set to.

 

[JoeMiller]

You can use the ActiveControl property to get this data. Try this code:

Dim ctlCurrentControl As Control
Dim strControlName As String
Set ctlCurrentControl = Screen.ActiveControl
strControlName = ctlCurrentControl.Name

That was taken right out of help from Access and will set strControlName equal the the control that currently has focus.



Joe Miller
joe.miller@flotech.net

 

[SmokingCrater]

Thanks Joe. I knew I had read it somewhere but couldn't remember where. Thanks again.

 

[pewilson]

What if you run into a situation where you want to specify the "setfocus", but all you get is "value" as your only option in the list box. What then?

 

[robinsdale]

This works unless the control is in a frame - ActiveControl will return the name of the frame, but not the control in the frame. How can I return the name of the control in that case?
Cheers,
Robyn