Basing Subform and Main Form on Same Table

Question

I want to base a subform and it's main form on the same table. There are 3 fields to be considered:

DvdMovieID (Autonumber)

DvdMovieTitle (Text)

DvdSynopsis (Rish tex Memo field)

I want DvdMovieTItle in a continuous form and teh DvdSynopsis on the main form.

Thanks,

James

Answer 1

The subform should not be linked to the main form, i.e. the Link Master Fields and Link Child Fields properties should be blank.

Create the following event procedure for the subform:

Private Sub Form_Current()

    If Me.NewRecord Then

         DoCmd.GoToRecord acDataForm, Me.Parent.Name, acNewRec

    Else

        Me.Parent.Bookmark = Me.Bookmark

    End If

End Sub

This will keep the main form synchronized with the subform

Answer 2

Hmm. Might just stay with my split form. Problem is there are issues when I place the datasheet on the left side. (No current X record of X in Navigation buttons at bottom.)

Answer 3

When I select a row in the subform the DvdSynopsis doesn't reflect the data with the selected record. When I select a row in the subform I want DvdSynopsis to show the data associated with that record.

Answer 4

So you want what I'd call an "upside down subform"? If there are 312 movies in the continuous subform, which of the 312 synopses do you want to see on the main form? The currently selected one?

I'm not sure if it is possible, but you could get the same effect by using two subforms on the same (unbound) mainform, one continuous (with nothing in its master/child link fields) and one single. You could have a textbox txtMovieID on the mainform, with its control source set to

=[continuoussubform].Form!DvdMovieID

You would then set the Master Link Field of the single form subform to the name of this textbox.

Answer 5

And your question is?