i am having problems using access 2003 as the front end connected to sql 2005 express as the back end when trying to create forms with subforms. Pulling up the main table retrieves everything in the linked table and not by the linked ID items.
ie.
StudentTAble
studentID
name, address, etc

ClassTable
ClassID
studentID
coursetitle, time, etc

when i setup a main form for StudentTable and then create a subform for ClassTable I want the forms to retrieve the student name and all the classes they are enrolled in. When I try to do this, I get the student name but in the subform it is retrieving all the classes in the ClassTable. I can't get it to bind to the studentID.

You need to go to the subform properties dialog box, and on the data tab, select the "Link Child Fields" and / or "Link Master Fields" and tell the form what to link on.

Did that work?

mmcdonal