By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,661 Members | 1,311 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,661 IT Pros & Developers. It's quick & easy.

Setting RecordSource

P: n/a
Hi

I Have A Main Form this form has a Subform The SourceObject for the
Subform is another subform.
I have mastered changing the SourceObject, so that I can have
different Subforms appearing when I need them BUT what I need to be
able to do is to change the RecordSource of the SourceObject Subform
from the code behind the Main Form, so I can reuse the SourceObject
Subforms

Thanks for any help
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Me.Subform.Form.RecordSource = "Your SQL or tablename or queryname string
here"

where Subform is the name of the control that holds the subform.

--

Ken Snell
<MS ACCESS MVP>

"Jimart" <ji****@iprimus.com.au> wrote in message
news:fb**************************@posting.google.c om...
Hi

I Have A Main Form this form has a Subform The SourceObject for the
Subform is another subform.
I have mastered changing the SourceObject, so that I can have
different Subforms appearing when I need them BUT what I need to be
able to do is to change the RecordSource of the SourceObject Subform
from the code behind the Main Form, so I can reuse the SourceObject
Subforms

Thanks for any help

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.