Syntax Error or Access Violation on Form/Subform

[jhmosow]

When opening a form with a subform, I get the error: Syntax Error or
Access Violation. It appears to be related to the Link Child Field and
Link Master Field properties. I want to link the forms by a field
called Template_Name that appears in both forms. If I remove the field
from either the Child or the Master, the error goes away but the
results in the subform are not filtered to match the form. This is an
ADP database. When I had this in form in an MDB, it worked properly.
Any thoughts, suggestions, workarounds?

Thanks

 

[John Vinson]

When opening a form with a subform, I get the error: Syntax Error or
Access Violation. It appears to be related to the Link Child Field and
Link Master Field properties. I want to link the forms by a field
called Template_Name that appears in both forms. If I remove the field
from either the Child or the Master, the error goes away but the
results in the subform are not filtered to match the form. This is an
ADP database. When I had this in form in an MDB, it worked properly.
Any thoughts, suggestions, workarounds?

Thanks

What's the datatype of the Template_Name field in the two tables?
Might there be some confusion between Fields named Template_Name with
Controls on the form with the same name?

John W. Vinson[MVP]

 

[jhmosow]

The data type for the field is nvarchar in both tables. I managed to
get it to work by recreating the subform. Don't know why, but it works
now.