Recordsource property of a subform

  • Thread starter Thread starter Candle
  • Start date Start date
C

Candle

Good Afternoon,

How can I set the Recordsource property of a subform on
the fly.

Thanks
 
Me.sfrmControlName.Form.RecordSource = "SomeQryName"

should do the trick. Where strmControlName is the name of the subform
control on the main form, not the name of the subform itself, unless they
are the same.

HTH
Steve C
 
Candle said:
Good Afternoon,

How can I set the Recordsource property of a subform on
the fly.

Thanks
Click to expand...

You have to get at it by way of the Form property of the subform control
on its parent form. From code on the parent form:

Me!SubformControlName.Form.RecordSource = ...

From code external to that form (and assuming the parent is a main form,
not a subform itself):

Forms!MainFormName!SubformControlName.Form.RecordSource = ...

Note that "SubformControlName" is the name of the subform *control* on
the main form, which may or may not be the same as the name of the form
object that it displays.
 

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

After changing the recordsource of a form, Disabling a button 1
Subform's RecordSource under Access 2007 sp1 2
Can't change recourdsource in subform 4
changing recordsource continuous subform in vba 2
Can pass subform Recordsource to a Report 6
Assigning a RecordSource to a subform 2
changing the recordsource of a subform 2
Change a Form's recordsource dynamically? 12

Back
Top