no text on subform when there are no child records

[susanhull]

Your help is appreciated. I'm relatively new to Access with no VBA
training.

My form calls GrantID and Grant# from tblGrant. The subform shows
current records from a query of tblQuestion and tblQuestionDescription
(tblGrant has a 1-to-many relationship with tblQuestion). When I
created the subform, I chose to have the subform fields related to
GrantID.

The challenge...if a Grant# doesn't currently have any related records
on tblQuestion, the labels and fields on the subform do not show - the
subform is blank. I want the user to be able to add records to the
subform that populate tblQuestion.

Also, I need to embed a subform within a subform within a subform.
Each level has a one-to-many relationship with the next level. The
hierarchy would look like this:
Grant# (form 1)
CoreQuestion# (subform 1, embedded in form 1)
IndividualQuestion# (subform 2, embedded in subform
1)
IndividualQuestionOptions (subform 3, embedded in
subform 2)

Will Access handle mutilple embedded subforms?

Thanks again for your time and expertise.

Susan

 

[Allen Browne]

For your first question, see:
Why does my form go completely blank?
at:
http://allenbrowne.com/casu-20.html
Hopefully once you understand what's causing it, you will be able to work
around it.

For your second question, Yes: Access can handle nested subforms. Current
versions cope with nesting 7 levels deep. Earlier versions were limited to
3.