Subform shows up Blank on main form

[Junior1544]

Hi everyone -

I have a subform that is showing up as a big white rectangle on my main form, instead of showing all the controls that the subform contains!

My main form is called "STUDENT FORM". It contains one subform called "Student_Courses Subform", which is displaying correctly, and another subform called "Tutee Entry Subform", which is showing up blank.

The "Student_Courses Subform" displays rows of courses in datasheet view. When I click on a row in this subform, I want to populate the various unbound text boxes and combo boxes that should be showing in the "Tutee Entry Subform". However, I can't see any of these controls!

The following line of code is in the "Student_Courses Subform" click event:

Private Sub Form_Click()
Forms![STUDENT FORM]![Tutee Entry Subform].Form!SSN = Me!AM_ID
End Sub

When this code executes, I get the error message:

"Runtime error '2467': The expression you entered refers to an object that is closed or doesn't exit."

Perhaps the error message might tip someone off as to what is wrong with my form. Can anyone help? Thanks for your time...

- Anita



junior1544@jmjpc.net
Life is change. To deny change is to deny life.

 

[BillPower]

Off the top of my head:

Check that the "Tutee Entry Subform's" SourceObject = TheSubFormName.

In Design View of "STUDENT FORM" click "Tutee Entry Subform", with the Tab "All" clicked, the SourceObject is the 2nd option in the Properties Window list. You can look at all Forms/Tables etc by selecting the dropdown list.

 

[aregan1]

That worked. Thanks for the help...

- Anita