RecordsetClone on a subform

J

johnb

Hi, I'm trying to reference a record source linked to a
subform using Access XP.
Set rec = Forms!frm_TopFormName.RecordsetClone works fine
at the Topform level but when try refer to the subform
rows with
Set rec = Forms!frm_TopFornName!
frm_SubFornName.RecordsetClone

I get "object doe not support this property of method".
Any suggestions on the correct syntax?

TIA johnb
 
A

Allen Browne

Try:
Set rec = Forms!frm_TopFornName.frm_SubFornName.Form.RecordsetClone

That's a reference to the form in the subform control.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

RecordsetClone on a subform 3
OpenRecordset SQL using wrong SQL statement 7
Dynamically assign a recordsetclone 1
GoToRecord for a subform 4
RecordsetClone and Subforms 2
Rowsource of combo box on subform 5
Assigning control sources via code 2
Problem with form--subform 5

Top