T
terri
I have a form that contains nested subforms bound to the previous via
multiple-field keys (which mirror the tables’ Primary Key), synchronized via
Child/Master links:
Main
SubformA Main1+Main2+Main3
SubformB Main1+Main2+Main3 + SubA
SubformC Main1+Main2+Main3 + SubA +SubB
There are two versions of the front end – one that links to tables in an
Access mdb and one that links to an SQL database. Identical queries are
stored in each front end that pass the data to the forms.
Everything works fine in the Access backend. Everything works in the SQL
backend EXCEPT saving a new record to SubformC. The form throws up error
#3101 – “…can’t find matching fields in (table SubformB)…â€
All the required keyfields for SubformC are filled in correctly from the
upstream forms and there is indeed a parent record in table SubformB. As a
test, in the BeforeUpdate event, I built an INSERT statement on the fly and
it executes without error. I wouldn’t mind manually doing the insert and
requery the form, however, I can’t cancel the BeforeUpdate Event -- I get a
message that record can’t be saved…
Any ideas?
multiple-field keys (which mirror the tables’ Primary Key), synchronized via
Child/Master links:
Main
SubformA Main1+Main2+Main3
SubformB Main1+Main2+Main3 + SubA
SubformC Main1+Main2+Main3 + SubA +SubB
There are two versions of the front end – one that links to tables in an
Access mdb and one that links to an SQL database. Identical queries are
stored in each front end that pass the data to the forms.
Everything works fine in the Access backend. Everything works in the SQL
backend EXCEPT saving a new record to SubformC. The form throws up error
#3101 – “…can’t find matching fields in (table SubformB)…â€
All the required keyfields for SubformC are filled in correctly from the
upstream forms and there is indeed a parent record in table SubformB. As a
test, in the BeforeUpdate event, I built an INSERT statement on the fly and
it executes without error. I wouldn’t mind manually doing the insert and
requery the form, however, I can’t cancel the BeforeUpdate Event -- I get a
message that record can’t be saved…
Any ideas?