Hi:

I have a database created in A2003 that I'm converting to A2007. It's
throwing an error that's driving me crazy because the code has worked
perfectly for years in A2003.

I have a main form with an unbound subform, and I change the subform's
recordsource based on what the user is doing. So there's some
standard code that handles that switch. The subform is called
"changeSub"

....snip
Me!changeSub.SourceObject = "xxx subform"
Me!changeSub.LinkMasterFields = "callID"
Me!changeSub.LinkChildFields = "callID"

It's failing on the 2nd line, with the error "the setting you entered
isn't valid for this property."

What am I doing wrong?

Thanks much.

Jan

"jan (AT) dontspamme (DOT) com" <jan (AT) stempelconsulting (DOT) com> wrote

Your code as written is referring to the subform control on your main form,
not the subform itself. You need to add .Form to refer to the subform, like
this:

Me!changeSub.Form.LinkMasterFields = "callID"
Me!changeSub.Form.LinkChildFields = "callID"

or:

With Me!changeSub.Form
.LinkMasterFields = "callID"
.LinkChildFields = "callID"
End With

Please ignore my last message. Brain fade.

jan (AT) dontspamme (DOT) com wrote:

Is it possible the subform name (property sheet) is different than the
form name in the database window?

On Oct 4, 7:22*pm, Salad <sa... (AT) oilandvinegar (DOT) com> wrote:
I don't think so.

The thing is, nothing has changed. It worked in A2003, it worked when
A2007 ran the A2003 database. But when I actually converted it to
A2007, it failed. So I'm thinking it's something that isn't allowed
in A2007 that was ok in prior versions.

jan (AT) dontspamme (DOT) com wrote:
Try setting both properties to "" prior to changing them to what you want.

On Oct 5, 6:27*am, Rick Brandt <rickbran... (AT) hotmail (DOT) com> wrote:
Brilliant! Thank you!