I
Ivan
I have a form with a tabbed area, for each tab the principle control (in most
cases only) is a subform. All link fields, master and child, are correctly
defined and use the primary key (or part of the primary key) in most cases.
All the subforms work correctly in that when progress from one record to
another in the main form the records in the subforms change appropriately.
However one of them sometimes doesn't, the key on the unlying table is based
two fields one of which matches exactly the type and size of the primary key
in the master form.
All the underlying tables are in a SQLserver Database with an ODBC link to
the Access mdb file which acts as an interface to SQL.
cases only) is a subform. All link fields, master and child, are correctly
defined and use the primary key (or part of the primary key) in most cases.
All the subforms work correctly in that when progress from one record to
another in the main form the records in the subforms change appropriately.
However one of them sometimes doesn't, the key on the unlying table is based
two fields one of which matches exactly the type and size of the primary key
in the master form.
All the underlying tables are in a SQLserver Database with an ODBC link to
the Access mdb file which acts as an interface to SQL.