ACCESS FEED: RE: [MS_AccessPros] Using subforms that are split forms

Minggu, 26 Agustus 2012

RE: [MS_AccessPros] Using subforms that are split forms - revisit

Rod-

I'm having a hard time picturing what you've done. Even when you put a Subform
control on a Tab control, the "Parent" of the form inside the Subform control is
still the outer form. Is the "split" form (form + subform) now in a subform on
a tab in some other form? Should still work fine. Which exact statement is
getting the error, and what is the complete error text?

John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)

-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of rodbevill
Sent: Monday, August 27, 2012 5:29 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [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

------------------------------------

Yahoo! Groups Links