B
Brian
I cannot seem to get the syntax correct for modifying the attributes of a
relation programmatically.
I can simply delete the relation, then re-create it with the correct
attributes using the .CreateRelation method as follows:
Set rel = .CreateRelation(relName, tblName, tblName2, relAttributes)
However, I get an "Incorrect use of property" error when I try to modify the
attributes as follows instead of delete/re-create:
rel.Attributes = dbRelationUpdateCascade
relation programmatically.
I can simply delete the relation, then re-create it with the correct
attributes using the .CreateRelation method as follows:
Set rel = .CreateRelation(relName, tblName, tblName2, relAttributes)
However, I get an "Incorrect use of property" error when I try to modify the
attributes as follows instead of delete/re-create:
rel.Attributes = dbRelationUpdateCascade