Subform in Continuous Form

  • Thread starter Thread starter Chaplain Doug
  • Start date Start date
C

Chaplain Doug

I am not allowed to place a subform in a "continuous" form
without first changing the form to "single." Why is
this? I would like to display more than one record on the
main form (i.e., I want it to be continuous) with each
record having the subform. How may I accomplish this?
Thanks.
 
Looks good. But how do I link the two forms (windows)?
The one on my left needds to be the master (or parent) and
the one on the right needs to be linked to it by filed
StudentID. Thanks for the help.
 
I simply set the recordsouce of the sub-form on the right side.

Here is the actual code I use for the listbox on the left side. I used the
after
update event:

Private Sub List51_AfterUpdate()

Dim subSql As String

If IsNull(Me.List51) = False Then
subSql = "SELECT * from FROM OldGroupTrips " & _
" WHERE [Gid] = " & Me.List51 & _
" order by TripDate DESC"

Me.OldGroupTrips_subform.Form.RecordSource = subSql
Me.OldGroupTrips_subform.Visible = True
End If

End Sub

So, there is no real link, I just built my own drill down. And, you could
use a sub-form on the left side also...and then use the on-current event of
the sub-form in place of the "afterupdate" I used for the listbox. How you
do this is up to you...and you can use a listbox, or a continuous sub-form
as my screen shots show...
 
Chaplain Doug,

If you set the Default View property of the first subform to Datasheet,
you can put a continuous view subform on it, and it will be displayed
when you click the [+] sub-datasheet icon on the first subform.
 
In your example, how did you get the selected record to be
highllighted (negative image)?
 
Chaplain Doug said:
In your example, how did you get the selected record to be
highllighted (negative image)?

The selected record on the left side is a listbox.

Read the caption/notes on that link ..and I explain that on the left side I
used a listbox....the right side is a continues form.


--
Albert D. Kallal (MVP)
Edmonton, Alberta Canada
(e-mail address removed)
http://www.attcanada.net/~kallal.msn




 
Back
Top