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.