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

Tab Question

P: n/a
I have a form with tab control. On each page of the tab is an instance of
the same subform which I want to have different data sources. How do I code
this? I've tried setting the "RecordSource" property in the enter and click
events to no avail.

Thanks.

Keith.
Jan 17 '07 #1
Share this Question
Share on Google+
5 Replies


P: n/a
Hi Keith,

Try coding the 'enter' event of the subformcontrols like:
Private Sub subFrmTab1_Enter()
Me!subFrmTab1.Form.RecordSource = "qryTab1"
End Sub

But you 'might' be better of still with duplicate subforms. Depends on what you need I guess.

Arno R
"Keith Wilby" <he**@there.comschreef in bericht news:45**********@glkas0286.greenlnk.net...
>I have a form with tab control. On each page of the tab is an instance of
the same subform which I want to have different data sources. How do I code
this? I've tried setting the "RecordSource" property in the enter and click
events to no avail.

Thanks.

Keith.

Jan 17 '07 #2

P: n/a
Keith Wilby wrote:
I have a form with tab control. On each page of the tab is an
instance of the same subform which I want to have different data
sources. How do I code this? I've tried setting the "RecordSource"
property in the enter and click events to no avail.
If you just want different filtering of the same base data then use a different
MasterLink property setting for each instance of the subreport. If it's totally
different base data, then using a common subform is probably not a good idea.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
Jan 17 '07 #3

P: n/a
"Arno R" <ar***********@tiscali.nlwrote in message
news:45***********************@text.nova.planet.nl ...

Cheers Arno. Just another quick one ... how do I set a sub-form's Allow
Edits property to False if the sub's on a tab control? I've tried
Me.sfrmName.AllowEdits but that gives me an error.

Thanks.

Keith.
PS did you get my recent e-mail?
Jan 17 '07 #4

P: n/a

"Keith Wilby" <he**@there.comschreef in bericht news:45**********@glkas0286.greenlnk.net...
"Arno R" <ar***********@tiscali.nlwrote in message
news:45***********************@text.nova.planet.nl ...

Cheers Arno. Just another quick one ... how do I set a sub-form's Allow
Edits property to False if the sub's on a tab control? I've tried
Me.sfrmName.AllowEdits but that gives me an error.
You could try Me!sfrmName.Form.AllowEdits=False

Keith.
PS did you get my recent e-mail?
I am not aware of any private mail from you last months.
When was the mail sent ?

Arno R
Jan 17 '07 #5

P: n/a
"Arno R" <ar***********@tiscali.nlwrote in message
news:45***********************@text.nova.planet.nl ...

"Keith Wilby" <he**@there.comschreef in bericht
news:45**********@glkas0286.greenlnk.net...
>
Keith.
PS did you get my recent e-mail?
I am not aware of any private mail from you last months.
When was the mail sent ?
Last week to the above address but with NO and SPAM removed. It was nothing
important, just a social call :-)

Keith.
Jan 17 '07 #6

This discussion thread is closed

Replies have been disabled for this discussion.