Passing focus to subform.....

[smorelandii]

I for the life of me can not seem to get the focus to pass to my subform. I have a main form with a few buttons and a datasheet subform. User enters data into the subform and clicks submit on the main form and the data is pushed to the appropriate tables. Need the foucus to be sitting in the 1st record, second column when the form opens. I've tried a number of things and can't seem to get it right. As usual, any and all comments are appriciated.



Main Form = CELL_ROOM_1_ACID
Sub Form = CELL_ROOM_1_ACID_SUB
Focus field on Sub Form = fldConductivity

Thanks.....

- Steve

[RuralGuy]

Moving the focus the mainForm to a SubForm in code is a two step process.
Me.SubFormControlName.SetFocus
Me.SubFormControlName.FORM.ControlName.SetFocus
...remembering that the SubFormControlName need not be the same name as the SubForm it displays.

[smorelandii]

Thanks RuralGuy....... Got the issue resolved. The code below works..... My sub form displays table CELL_ROOM_1 but is named CELL_ROOM_1_ACID_SUB...... I was using the wrong name when referencing it.... Thanks you very much.... Issue resolved.

Me!CELL_ROOM_1.SetFocus
Me!CELL_ROOM_1.Form!fldConductivity.SetFocus

[RuralGuy]

Excellent! Glad we could help.