RecordsetClone on a subform

  • Thread starter Thread starter Ronald
  • Start date Start date
R

Ronald

Hi.
From a subform on a form I need to reach the recordsetclone of another
subform on that form.
I've tried:
Set rst = Forms![<main form>]![<other subform>].RecordsetClone
Set rst = Forms![<main form>].Form![<other subform>].RecordsetClone
Set rst = Forms![<main form>]![<other subform>].Form.RecordsetClone
Set rst = Forms![<main form>].Form![<other subform>].Form.RecordsetClone
Set rst = Forms![<main form>]![<other subform>].Form![<other
subform>].Form.RecordsetClone
Set rst = Forms![<main form>]![<other subform>].Form![<other
subform>].RecordsetClone

but the 'best' error I get is that the property is not supported.

What contruction will work and why?

Thanks,

Ronald.
 
The 2nd subform is a subform of the first subform? If so:

Set rst = Forms!nameofMainForm!nameofIst SubFormControl.Form!nameof2nd
SubFormControl.Form.RecordsetClone

Use the names of the subform controls not the subforms.

HTH
 
If the second subform was within the first one I would have said so.
One of these statements should work, but they do not:
Set rst = Forms![<main form>]![<other subform>].RecordsetClone
Set rst = Forms![<main form>].Form![<other subform>].RecordsetClone
Set rst = Forms![<main form>]![<other subform>].Form.RecordsetClone
Set rst = Forms![<main form>].Form![<other subform>].Form.RecordsetClone

Why?

Jon Lewis said:
The 2nd subform is a subform of the first subform? If so:

Set rst = Forms!nameofMainForm!nameofIst SubFormControl.Form!nameof2nd
SubFormControl.Form.RecordsetClone

Use the names of the subform controls not the subforms.

HTH

Ronald said:
Hi.
From a subform on a form I need to reach the recordsetclone of another
subform on that form.
I've tried:
Set rst = Forms![<main form>]![<other subform>].RecordsetClone
Set rst = Forms![<main form>].Form![<other subform>].RecordsetClone
Set rst = Forms![<main form>]![<other subform>].Form.RecordsetClone
Set rst = Forms![<main form>].Form![<other subform>].Form.RecordsetClone
Set rst = Forms![<main form>]![<other subform>].Form![<other
subform>].Form.RecordsetClone
Set rst = Forms![<main form>]![<other subform>].Form![<other
subform>].RecordsetClone

but the 'best' error I get is that the property is not supported.

What contruction will work and why?

Thanks,

Ronald.
Click to expand...


.
Click to expand...
 
Ronald said:
If the second subform was within the first one I would have said so.
One of these statements should work, but they do not:
Set rst = Forms![<main form>]![<other subform>].RecordsetClone
Set rst = Forms![<main form>].Form![<other subform>].RecordsetClone
Set rst = Forms![<main form>]![<other subform>].Form.RecordsetClone
Set rst = Forms![<main form>].Form![<other subform>].Form.RecordsetClone

Why?
Click to expand...

If <other subform> refers to the name of a *subform control* on your <main
form>, then:

Set rst = Forms![<main form>]![<other subform>].Form.RecordsetClone

should definitely work.
 
Back
Top