Thanks John,
I will try that today.
Rod
--- In MS_Access_Professionals@yahoogroups.com, John Viescas <JohnV@...> wrote:
>
> Rod-
>
> As you've discovered, a Split Form View loses its "splitness" when you embed it
> as a subform. To do what you want, you have to build a "split" form the
> old-fashioned way. Change your current form to Single Form View. Create a
> second form on the same Record Source and save it in Datasheet view. Embed that
> Datasheet on your original form and make sure the Link properties are not set.
> Then add code to the Current event of the subform in Datasheet view to keep the
> two in sync:
>
> 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
>
> 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/
> (Villefranche-sur-mer, France)
>
> ------------------------------------
>
> From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of rodbevill
> Sent: Sunday, April 22, 2012 7:27 AM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: [MS_AccessPros] Using subforms that are split forms
>
>
> I have started a new application for a local client. The app involves data that
> I have divided into tables based on the type of data; i.e., correspondence,
> payments, communications (internal), property, protest, etc. The main screen
> will have the company information in the upper half of the screen and a tap
> control in the lower half for each of the above mentioned data types. Within
> each tab is a subform that specifies the data required and optional, the issue I
> have is trying to create a couple of the subforms as a split form. When the
> subform is created and tested standalone everything appears fine; however, when
> put on the main screen and the specific tab is selected the subform does not
> appear split (only the upper half - non datasheet appears).
>
> Is there a way to accomplish the approach I am looking for or do I need to try
> something else? The reasons for the split form is to allow the user to view
> history for data such as payments and correspondence.
>
> Rod
>
Tidak ada komentar:
Posting Komentar