Setfocus from split form to main form

[CNW]

I have a form set to split form view. The split form has two fields displayed. The main form has all fields displayed. I have a VBA routine defined so that when I change contents of the combo box title field it requeries the form and setfocus to a field displayed on the main form. All works fine if I am on the main form as all fields are showing. However, if I do the same on the split form view it errors out as the field into which I want to set focus is not displayed on the split form view. I want this to work either way as I will not be the only user. I have tried Forms!f_Techniques.SetFocus followed by Forms!f_Techniques.form.narrative.setfocus but can not get the focus back to the main form from within VBA. Is there specific syntax to reference the main form verses the split form? Thank you in advance for any assistance offered.

[June7]

How do you not display fields in the datasheet part of split form while they are displayed in the single part? With right click Hide/Unhide?

I think you might have run up against a deficiency of split form. I can't find any way to address the single or datasheet parts of the split form. Only thing I found was this thread showing use of SendKeys to cycle through parts of db and form http://www.utteraccess.com/forum/Set...-t1974783.html

[Missinglinq]

Not sure I'd call this a 'deficiency' of split form! The primary purpose of this new (in 2007/2010) feature is to allow you to use the Datasheet portion of the Form to quickly locate a Record, and then use the Form portion to easily View or Edit the Record. Previously, to have this kind of functionality, and it is something developers/users frequently wanted, you'd have to

1. Display all Records in a Datasheet View Form
2. Grab the Primary Field of the Current Record
3. Write code to open a second, Single View Form, to the Record that matches the PK
4. Do whatever to the selected Record
5. Close the secondary Form
6. Return to the Datasheet View Form

Now, all you have to do for this functionality, is to set the Default View Property of the Form to Split Form. If used for the purpose that it was developed for, it's not deficient at all!

If you want to prevent the error, i.e. keep users from utilizing the Combobox while on the Datasheet portion of the Form, the only thing I can think of is to set the Split Form Datasheet Property from Allow Edits to Read Only.

Linq ;0)>

[CNW]

Thank you June7 and Missingling for your replies. It appears that the best solution might be to set splitform portion to read only forcing edits on main form as you suggest Missingling. I looked at any other way I could programmatically accomplish a shift back to main form but never came up with an option. If I do will edit this post. Thank you again!

[June7]

Yes, I can see 'deficiency' was wrong choice of word. Trying to use a tool as it wasn't intended will lead to frustrations. I like to set up forms so can be navigated without mousing and just haven't found use for the split form.

[CNW]

I have found a workable solution to issue. This form is based on multiple tabs. By putting an OnClick event in each field of the splitform I can fire code to shift focus back to main form. See following code for details.
'---------------------------------------------------------------------------------------
' Procedure : LName_Click
' Author : CNW
' Date : 06/18/2013
' Purpose : Used for subdatasheet to focus back to main form.
'---------------------------------------------------------------------------------------
'
Private Sub LName_Click()
If Nz(Me.ubLogin) = "" Then
MsgBox "Entry is required!", vbCritical
Application.Echo False
Forms.f_Cont.Form.Purchased.SetFocus
Forms.f_Cont.SetFocus
Forms.f_Cont.ubLogin.SetFocus
Application.Echo True
End If
End Sub
Missingling and June7 I hope you are doing well.