School (Main Form) record source = School

Courses (Sub Form 1) record source = Courses. Master/Child = School ID.

Sites (Sub Form 2) record source = Sites. Master/Child = Course ID.

The database needs to do this:

1 School has many Courses. Each course has many sites. From the Course
subform (to Schools) I want an action button that filters the sites for the
selected course...

Thanks...

"John W. Vinson" wrote:

On Thu, 6 Mar 2008 10:52:00 -0800, -LWG-
wrote:

Main Form: School
Subform: Courses (1 to many from School)
Subform2: Sites (1 to many from Courses)

Everything works fine when the form and both subforms are displayed. When I
add a record to subform2 the Courses ID auto-populates which I want.

However, when I open Subform2 from an action button and click add record,
the Course ID does not auto-populate.

Help?

What's the Recordsource of each form? Post the SQL. Why should CourseID
autopopulate, if it's not (part of) the master/child link field?
--
John W. Vinson [MVP]