Set focus to button on Form Header

[TylerTand]

I have had a hard time setting the focus on a button when a Form opens if the button is in the Form's Header. I just can't seem to make this work. Your help with this annoying problem is appreicated

 

[boblarson]

What have you tried so far?

 

[TylerTand]

I have tried everything I can think of from:

On Open: [Command25].setfocus

[forms]![KeywordSearchResults].[command25].setfocus

[Forms]![KeywordSearchResults].Section(1).[Command25].setfocus

If I could just set the Tab order to start with the Header I could send it right to the button but I can't seem to figure that out either.

Help!

Thanks,
Tyler

 

[TylerTand]

Thanks Bob but I just figured it out.

I just put behind the button that opens the form to not only set the record source but also to set the focus on the command button. I thought I already tried that but who knows