I am using a button on a command bar to change a subform on my main form. My problem is that it doesn't set the focus to the subfrom or any control on it. I have tried using setfocus on both the subform and controls on it, no luck.

Please help!
Thanks!

Try this article, it might help your situation.
http://support.microsoft.com/?kbid=209689

Are you sure you're referring to the control on the subform correctly? Suppose you had a form called frmMyMainForm and a subform called sfrMySubForm. On the subform you had a textbox called txtMyTextBox. Then on the button's On Click event, setting the focus would look something like this.

Button is on the main form:

   Me.sfrMySubForm.Form.txtMyTextBox.SetFocus

Button is on the subform:

   Me.txtMyTextBox.SetFocus


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division