Sub-Forms Don't work after linking tables

[gprabhav]

I am migrating MS access 2000 application into MS access 2010 front-end and SQL Server 2012 express back-end.
The front-end talks to the back-end via ODBC based Linked tables.

The application has 1 Parent table and 5 Child tables with 1 to Many relationships.


The application has 1 Form for Parent table and 5 pages within it, each with its own sub-forms for child tables.

After the migration, I can enter data in the Main Form(Parent Table) but CANNOT ENTER ANY DATA in the sub-form (Child tables)
The check-box, text-box, combo box on the sub-forms with control source in the Child table refuses to work.

Any Clues ???

Thanks.

[gprabhav]

I am adding Additional Information:
The Main Form has multiple Pages/Tabs.
3 Pages/Tabs have sub-forms within it WHICH ARE WORKING.
2 Pages/Tabs have fields from Child table within it.....WHICH ARE NOT WORKING.
The child table fields are joined to the Master table through a query on the main form.

Is it not working because of the Join - you cannot update tables in SQL server via JOIN ???
Do I need to bind each child table field via a query.

[vincent-leeway]

Yes you need to write some code to transfer an id into subforms and populate the controls in the sub forms.