Subform Problem

[nchesebro]

I have a form that has a subform placed within it. Within that particular subform, there are also three our four seperate subforms.

Reservation Form
--Student Data Subform
----Subform 1
----Subform 2


----Subform 3
----Subform 4

When looking at the Student Data Subform on its own, I can complete all the fields without any error messages, and it saves information as it is supposed to (Record 1 Data stored in Record 1, Record 2 Data stored in Record 2....)

However, when I put the student data subform into the Reservation form, all of my dropdown boxes throw an error about "you are trying to assign a null value..." and records are not stored properly (Record 1 Data and Record 2 Data stored in one single record, not two or three, or however many you need)

Am I just too many subforms deep? Or do I need to look at my relationships? I have been spending weeks trying to figure this out to no avail. I can post the db online for your viewing (in 2010 format) if that would help.

[alansidman]

Does this video on relationships and subforms help you.

Alan

[nchesebro]

Which video? :P

[nchesebro]

ha. Wasnt searching with the right words. In bold print from MSDN...

Access won't let you have a subform within a subform if the data has to be displayed in a continuous form.

Awesome. Onwards with a new plan...

[alansidman]

Senior Moment. Sorry. But I see, you may already have solved the issue.

http://www.datapigtechnologies.com/f.../subform2.html

Alan

[nchesebro]

My discovery poses another problem... in the heirchy of subforms I presented earlier, in theory, i could click a button and save all subforms in conjunction with the student subform, and have a clean slate to enter another students information. Now, I am a bit puzzled as to how to approach this given that I can only go one sub-form level deep...

[nchesebro]

Looking at the gray region on frmReservation, you will see all the subforms are related in the data that they store for the student entered at the top. I have the relationships built the best I know how, but all the subforms are still acting independently, rather than based on the student subform. There is no codebehind for the buttons below, but you can navigate (in theory) using the buttons on the student subform.

I must have relatinships setup incorrectly, if you would look them over and point me to the problem, i would greatly appreciate your insight.

[nchesebro]

Maybe I could place buttons on each subform, and then change them to invisible, then use a button placed on the main form to call the individual buttons on the subform...

Would that work??? If it would, other than what I have mentioned already, I am not familiar to how to do this in VB and an example would help me get started.

Thanks