tab control syntax

  • Thread starter Thread starter TC
  • Start date Start date
T

TC

Each subform is in a subform control. The names of those controls are
different - no two of them share the same name. So it is actually irrelevant
what tab pages they are on.

This will set the recordsource of the subform cointained in the subform
control named sf1:

me![sf1].form.recordsource = ...

HTH,
TC
 
You have a problem with the date on your PC.
Please change it to the correct date.
You wouldn't want someone to think you post dated your question so it would
be at the top of the list.
 
Apparently you have been posting this message quite a bit.

This is likely NOT a local PC problem because many posts have strange times.

Notice that your complaint appears as 7:09 pm, and the other reply posted as
9:50pm

My computer time is now 9:00 am Pacific Time.
 
But if the recordset is not assigned when the main form loads, it is too
late to assign the recordset when the subform is clicked because it would be
blank until clicked. ie. when the tab is clicked, it will show a blank
subform until someone clicks on the subform, but then why would they do that
becasue it is blank...


TC said:
Each subform is in a subform control. The names of those controls are
different - no two of them share the same name. So it is actually irrelevant
what tab pages they are on.

This will set the recordsource of the subform cointained in the subform
control named sf1:

me![sf1].form.recordsource = ...

HTH,
TC


Garret said:
New to using the tabbed control, and I am struggling with the proper syntax
to set the recordsource of the subforms on each tab. I have an unbound text
box on the main form that I am going to use as a parameter in the SQL
statement to set the REcordSource of the subforms.

I have a tab control named "MainTab", with 3 tabs (tab0, tab1, tab2). I have
a subforms on each tab named sbform0,..1, ..2.

I tried access the recordsource with:
msgbox ME("Tab0")("sbform0").Recordsource
but it did work

What is the proper syntas? Thanks for the help
Click to expand...
Click to expand...
 
I believe I mentioned the date, not the time.
As I recall (since I delete all future posted messages) your post was a
month ahead.
(Or a few days anyway.)

No one nitpicks over a couple of hours.
 
You asked for the syntax to reference the recordset of a subform. I gave
you that syntax :-)

How about explaining what you are trying to achive from an end-user
viewpoint? You are describing things that (apparently) do not work. It's
difficult to work backwards, to deduce what you are actually trying to
achieve.

Cheers,
TC


Brian said:
But if the recordset is not assigned when the main form loads, it is too
late to assign the recordset when the subform is clicked because it would be
blank until clicked. ie. when the tab is clicked, it will show a blank
subform until someone clicks on the subform, but then why would they do that
becasue it is blank...


TC said:
Each subform is in a subform control. The names of those controls are
different - no two of them share the same name. So it is actually irrelevant
what tab pages they are on.

This will set the recordsource of the subform cointained in the subform
control named sf1:

me![sf1].form.recordsource = ...

HTH,
TC


Garret said:
New to using the tabbed control, and I am struggling with the proper syntax
to set the recordsource of the subforms on each tab. I have an unbound text
box on the main form that I am going to use as a parameter in the SQL
statement to set the REcordSource of the subforms.

I have a tab control named "MainTab", with 3 tabs (tab0, tab1, tab2).
Click to expand...
I
have
a subforms on each tab named sbform0,..1, ..2.

I tried access the recordsource with:
msgbox ME("Tab0")("sbform0").Recordsource
but it did work

What is the proper syntas? Thanks for the help
Click to expand...
Click to expand...
Click to expand...
 
Garret,

A tab control is only an extension of the form it is on. So you add controls
including subform controls to a tab control in the same way you add them to any
other form. The tabs are merely a way to navigate to the extensions.
 
Woops - I responded to the wrong thread (I posted a similar one)

The posted time does match my local computer time.
Click to expand...

It's the DATE of your post that is incorrect, not the time.
Some posters do that intentionally.
I doubt any one would object to a Time being incorrect, but I for one
delete all messages that are DATED more than one day in the future so
that it doesn't sit at the top of my list until then.
 
New to using the tabbed control, and I am struggling with the proper syntax
to set the recordsource of the subforms on each tab. I have an unbound text
box on the main form that I am going to use as a parameter in the SQL
statement to set the REcordSource of the subforms.

I have a tab control named "MainTab", with 3 tabs (tab0, tab1, tab2). I have
a subforms on each tab named sbform0,..1, ..2.

I tried access the recordsource with:
msgbox ME("Tab0")("sbform0").Recordsource
but it did work

What is the proper syntas? Thanks for the help
 
Back
Top