Continuous form with subform

[DavisGail]

I cannot figure out how to make this form:

I want to create a form that pulls a list of students from a query based on
specific criteria. (ClassDate, Pass/Fail of certain prerequisites, etc.) Got
that part. Next, I want to have a subform that I can enter data for each
student.

My problem is that I have my main form as a continuous form and cannot have
a subform. Is there a better way???

 

[Daniel Pineault]

Sadly, you cannot add a subform to a continuous form.

One option would be to use a form in datasheet view and the subform would
then become a sub-datasheet.

Another approach would be to create a child form..., refer to :
http://bytes.com/topic/access/answers/851809-continuous-forms-subforms
http://groups.google.com/group/comp.databases.ms-access/msg/70bc13deac192275
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.

 

[Bob Quintal]

I cannot figure out how to make this form:

I want to create a form that pulls a list of students from a query
based on specific criteria. (ClassDate, Pass/Fail of certain
prerequisites, etc.) Got that part. Next, I want to have a
subform that I can enter data for each student.

My problem is that I have my main form as a continuous form and
cannot have a subform. Is there a better way???

I've kludged this scenario by using two subforms on an unbound parent
form, using some code to synchronize the subforms by populating unbound
textboxes on the parent form from one subform, which serve as the link
master fields for the other subform