Data Not Showing Up In Form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I have a form called "Student Records"

In that form, there is a subform called "classes"... It dispalys all class
that student is signed up for. The classes subform is based off of a query
that displays all classes the student is in.

When I run the query, it displays all the classes that student was signed up
for, however, the Subform displays NONE of those records.

In the subform I can create new records for the student.. but they still
won't be displayed.

I have spent several hours and am baffled.. why won't the data the Shows up
in the query not be displayed in a form that runs off of the query?

Thanks!

AD
 
Couple of things to check.

1. Open your main form in design view.
2. Right-click the edge of the subform control, and choose Properties.
3. Check that the LinkMasterFields property is the name of the main form's
primary key (probably StudentID), and that the LinkChildFields property is
the name of the matching field from the subform.

If that looks right, open the subform's table directly. It will have a
foreign key field (the one that relates to the StudentID in the main table).
Is this field being populated correctly, or is it blank?
 
I have made sure that the masterfield and child field are properly linking to
eachother.. but still no go...

Any other ideas??
 
Back
Top