[AccessD] Setting the LinkMaster/Child field

Yes, I have.  I found that this tends to happen when there is already a
string in the property, so I got around it by testing for an existing
string.  Also, be careful what event you're trying to use to set the
property.  Don't try to set the links in the Open event of the parent
form, although you can set the subform object there.  You can set both
in the Load event of the form, however.

Charlotte Foust


-----Original Message-----
From: Colby, John [mailto:JColby at dispec.com] 
Sent: Tuesday, November 16, 2004 11:54 AM
To: 'AccessD at DatabaseAdvisors.com'
Subject: [AccessD] Setting the LinkMaster/Child field


In code I am attempting to set the LinkChildFields and LinkMasterFields
properties of the subform control.  I get a runtime error 2101 "The
setting you entered isn't valid for this property" even though if I go
back and look at the property it is set to the value I placed in it.
Has anyone encountered this?  

It appears that this is a string property (text) which is interpreted by
the control at subform load time.

John W. Colby
The DIS Database Guy

-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com