Trouble Synching Form and SubForm

[Guest]

Access 2003. I have a form that contains a subform. The form's recordsource
is a table called Classes and the subform's recordsource is a table called
Class Definitions. The tables are linked by the primary index in the main
table Classes.

The problem I am having is that when I use the navigation buttons to move to
a new (empty) record in the main form. I am able to enter data in the main
form. But when I begin to put data into the subform, I am moved to what was
previously the last record in the main table. The result is that the data I
enter in the subform is not related to the new record I created, but is now
related to what was the last record in the main table.

Why is this happening? How can I fix this? Thanks and God bless.

 

[Guest]

Are the Child and Parent properties of the Sub Form control wthinn the main
form are set?

If not, you need to link the min form and the sub form using this properties.
In the Parent property enter the name of the primary index field in the main
table
In the Child property enter the name of the primary index field in the
secondary table

 

[Guest]

Dear Ofer:

Yes the parent/child properties are set to the proper fields. What else
could be causing my problem? Thanks.