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]