How to Set Focuse to a subform control from other subform controls??

[rawled]

I have created a navigation form which contains a few nested sub forms. They are like this.

frmNavigation is the main form which has navigation buttons and a sub form named NavigationSubForm.

NavigationSubForm: Its source object is a form named sfrmNavigation.

sfrmNavigation has a sub form named subAddNewStudent.
subAddNewStudent: Its source object is a form named sfrmAddNewStudent.
I want to hide the subAddNewStudent subform with an on click event of a button on sfrmAddNewStudent. To do that I want to set focus of the button to another button on NavigationSubForm.
I am new to Visual Basic. My procedure to solve the problem may be wrong. Hope you got my problem. You will get my intention from the code below:

Private Sub btnClose2_Click()

'btnClose2 is a button on sfrmAddNewStudent

Forms! NavigationSubform.btnEdit.SetFocus

'btnEdit is a button on NavigationSubForm

Forms! NavigationSubform.subAddNewStudent.Visible = False

End Sub

It would be a great help if anyone comes forward. Thanks in advance.

[twinnyfo]

rawled,

You may have to state the Form explicitly, including the parent forms. For example, try using the following syntax:

Forms!frmNavigation.sfrmNavigation.btnEdit.SetFocus

You must use the actual object names on each form.

Hope this hepps!

[rawled]

Best way for this is to seek help from the expression builder. At first I did not know about that. I hope it will help other newbies in future.

Thanks for your reply twinnyfo.

[twinnyfo]

Yes, the Expression Builder can be very helpful when you are unsure of the syntax. Sometimes it can get confused with deeply embedded forms (triple or quadruple nested). But for your application, this will work perfectly.

Glad I could be of some hepp!