I have migrated a SQL server 2000 database to SQL Express 2008. Once reassignd roles and permissions, it seems working, however in a form (+subform) when adding new records to the subform, the following error message is given, although the record is still added to the underlying table:
The data was added to the database but the data won't be displayed in the form because it doesn't satisfy the criteria in the underlying record source.
The article here describes a workaround to the problem, however the recordsource is created dynamically; once contents change in the main form, the recordsource property will change in the subform accordingly. Is there a way to fix this?