Changing Child/Master Links in code

[aggieval]

I am having an issue with a form that has run correctly for months and is now not working. Based on data entry in the main form, I am updating the record source of a subform that is not linked to the main form. I have been telling the subform to set the linkedchildfields and linkmasterfields = "" otherwise it will default it to a related field on each form. Now this doesn't work on my clients computers (it still works on mine).

Has anyone experienced this or have any suggetions. I am thinking is may be a setting on the database or form.

Thanks.

 

[MissTipps]

I'm a bit puzzled by this, to be honest. For a start, your application should not set any default child/master links. I've certainly never experienced it, unless you have the wizard turned on when you drag a subform onto your main form???


Not sure what I can suggest. Try getting rid of that empty string??

 

[aggieval]

I am not sure what wizard you are talking about. If there is something I can turn off, yeah. If I get rid of the empty string, then the application makes Ind# the link. Again, I think there is a setting that has changed either on the form or in the database itself, but I can't figure out what it is.

Thanks again for any input.

 

[scriverb]

Try setting the Link Child Field and Link Master Field to Null rather than empty strings. The empty strings may be being interrupted as a value to try to link with.

I have done this before. Also try removing the SourceObject and setting the above to Null before you replace it with the New SourceObject which doesn't have the links. Then requery the main forms Subform object.

Just some ideas.

It is strange that it is working okay on your PC then not on the end users. Possibily a different build? Service Pack?

Bob Scriver