How to fill text boxes for the same foreign key??

[ost3z]

i have build a small project using access 2003 and vba code one of the forms contains sub form the main form contain the main data about school and in sub form populate different > textboxes for details about classes my problem is how to fill these text boxes in this sub >form for different grades depending on id of main form and how can i change the values and >moveing first or next buttons these are simple picture for the idea can anyone help ??

 

[Galaxiom]

The subformcontrol should have its LinkMasterFields and LinkChildFields properties with the key fields on the main form and subform respectively.

New records in the subform will automatically populate the LinkChildField from the designated LinkMasterField.

 

[ost3z]

this my project link could you have a look ??

 

[ost3z]

up i need help ??????

 

[Galaxiom]

up i need help ??????

Have you looked into the properties of the subform control that I mentioned? You could post a comment on what you found so I might have some idea if I am on the right track.

As a developer it is important that you understand the properties of the subform and it structure. You won't get that knowledge by asking people to fix your database for you.

Developing takes a bit more perseverance than is immediately apparent in an OP uploading their sample database just ten minutes after getting a response without including so much as a single word of feedback on the offered suggestion.

 

[ost3z]

thankx for your feedback i really change my relation database and follow your advice
( The subformcontrol should have its LinkMasterFields and LinkChildFields properties with the key fields on the main form and subform respectively.

New records in the subform will automatically populate the LinkChildField from the designated LinkMasterField. )
now it works fine many thankx