Changing RecordSource of a second subform

[floydman]

I have a mainform with 2 unbound subforms, when a new record is selected on subform1 I want to move focus and change the recordsource of subform2 and requery.

In the Current Event of sub1 I have:

Me.Parent!sub2.Form.RecordSource = strSQL
Me.Parent!sub2.Form.SetFocus
Me.Parent!sub2.Form.Requery


I was getting a message saying object closed or doesn't exist but I am now getting a you cancelled the previous operation error.

Can anyone point me on the right direction to control this second subform from the first ?

Cheers

 

[gemma-the-husky]

do the requery before the setfocus, i think

instead of Me.Parent!sub2.Form.Requery

try parent!subdetails2.requery (ie - whatever the subforms name is on the parent form)

 

[floydman]

Oh, forgot to add that the error is on

Me.Parent!sub2.Form.RecordSource = strSQL

 

[gemma-the-husky]

with a form it might be

.sourceobject, rather than recordsource

or it might be the syntax you are using to address the subform

--------
not sure, and I haven't got time to try it at the moment, sorry