[MS_AccessPros] Using subforms that are split forms - revisit

 

I have developed a split form using the manual approach described in an earlier post. The main form is defined as a single form then a second copy is created using the datasheet view as the default. This datasheet view is added to the single form to create the split form. The link fields are blank and the following code is use in the current method of the datasheet view:

Private Sub Form_Current()
' If on a new Record,
If Me.NewRecord Then
' Move the outer form to a new record
Me.Parent.SetFocus
RunCommand acCmdRecordsGoToNew
Else
' Sync the outer form by copying the Bookmark
Me.Parent.Bookmark = Me.Bookmark
End If
End Sub

This process appears to work fine with the form is opened. However, when I add the split form to tab control on the main application form I get an error 2449 invalid method. I thought the datasheet view would use the other have the split form as the parent. Is this a wrong assumption? If so what would I call the other half of the split form once it is added to the Main application? Currently no data has been entered into the system, just trying to get the initial system to accept data with new data by user.

Rod

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 7

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___