Tabbed form using different criteria

[upsman via AccessMonster.com]

Hi.

I have a table containing student grades. This table contains grades for
multiple school years and I use a field called 'SchoolYr' to select the
grades for the year I want. I'd like to create one form with multiple tabs
representing the different school years. For instance, I'd have tabs for 03-
04, 04-05, and 05-06. All the data would be coming from the same table.
How would I set up the tabs to get the data from one table but select it
based on different criteria for each tab? Hopefully that is somewhat
understandable. I know I can use subforms with different Record Sources but
I'd have to have a new subform for each year and I'd end up with alot of
subforms over a period of time. I'm hoping I can do it with code in the tab
somewhere or set the Record Source of each tab somehow.

Appreciate any help you can give.
Rod

 

[Gordon Padwick]

Sounds like what you want to do is quite possible. To be able to give you
useful help, though, I need to have a copy of your table (or one like it)
and also a sketch of the form you require.

If you want me to look at this in detail, you might want to send me an
abbreviated table with dummy student names.

Gordon

 

[strive4peace]

Hi Rod,

instead of using tabs, why not have SchoolYr be one of the
LinkMasterFields and LinkChildFields? Then, in your subform
recordset, include all the records.

they won't be looking at 2 school years at the same time
anyway

I you DID want to see multiple school years at the SAME
time, you can use calculated controls or comboboxes for
LinkMasterFields and the same subform

Warm Regards,
Crystal

MVP Microsoft Access

remote programming and training
strive4peace2006 at yahoo.com
*
Have an awesome day

 

[upsman via AccessMonster.com]

Crystal,

Can you have more than one field in the LinkMasterFields and LinkChildFields?
Right now I have StudentID as my LinkMasterFields and LinkChildFields because
they're wanting to view the grades for a particular student. No, they will
not want to view 2 school years at the exact same time but they will want to
look at the grades from last year and this year for a student by somehow
switching between the 2 years. That's why I thought of using tabs; they'd
just click back and forth between the 2 tabs to see the grades for the 2
years.

Rod

Hi Rod,

instead of using tabs, why not have SchoolYr be one of the
LinkMasterFields and LinkChildFields? Then, in your subform
recordset, include all the records.

they won't be looking at 2 school years at the same time
anyway

I you DID want to see multiple school years at the SAME
time, you can use calculated controls or comboboxes for
LinkMasterFields and the same subform

Warm Regards,
Crystal

MVP Microsoft Access

remote programming and training
strive4peace2006 at yahoo.com
*
Have an awesome day

Hi.

[quoted text clipped - 12 lines]

Appreciate any help you can give.
Rod

 

[strive4peace]

Hi Rod,

yes, you can seperate the controlnames with semi-colon

use the NAME property of the control, not the ControlSource
(fieldname for bound controls). To ease confusion, I assign
the Name property to be the same as the ControlSource for
bound controls

The SchoolYr control on the main form will be unbound. Once
again, to ease confusion, you can make the NAME of the
control --> SchoolYr

as you are using control names, obviously, you have to HAVE
the control on each form -- usually, the link controls on
child forms have the VISIBLE property set to false

LinkMasterFields --> StudentID; SchoolYr
LinkChildFields --> StudentID; SchoolYr

Warm Regards,
Crystal
MVP Microsoft Access

remote programming and training
strive4peace2006 at yahoo.com
*
Have an awesome day

Crystal,

Can you have more than one field in the LinkMasterFields and LinkChildFields?
Right now I have StudentID as my LinkMasterFields and LinkChildFields because
they're wanting to view the grades for a particular student. No, they will
not want to view 2 school years at the exact same time but they will want to
look at the grades from last year and this year for a student by somehow
switching between the 2 years. That's why I thought of using tabs; they'd
just click back and forth between the 2 tabs to see the grades for the 2
years.

Rod

Hi Rod,

instead of using tabs, why not have SchoolYr be one of the
LinkMasterFields and LinkChildFields? Then, in your subform
recordset, include all the records.

they won't be looking at 2 school years at the same time
anyway

I you DID want to see multiple school years at the SAME
time, you can use calculated controls or comboboxes for
LinkMasterFields and the same subform

Warm Regards,
Crystal

MVP Microsoft Access

remote programming and training
strive4peace2006 at yahoo.com
*
Have an awesome day

Hi.

[quoted text clipped - 12 lines]

Appreciate any help you can give.
Rod