Dumb question about tabs or tabs with subforms

[Afrosheen via AccessMonster.com]

First of all, thanks for reading this post.
I have one table with lots of fields in it. The field I'm concerned with this
post is [shift]. I've created filters which will filter out Day Shift or
Night Shift. I've created a tabbed formed with two subforms with the exact
same info except they are Tab 1 is Day Shift. Tab 2 is Night Shift and
filtered accordingly. So that means twice the programming. For example if I
have to change one item in tab 1 subform then I'd also have to change it in
tab 2 subform.

The dumb question is which would be more efficient putting all the fields on
blank tabs or using the subforms? I know I'd somehow have to come up with a
way for the Day Shift and Night Shift to be filtered on each tab.

Instead of using filters, would it be better to build an SQL string?

I don't know. That's why I call it a dumb question.

Thanks again for reading this.

 

[Dennis]

Why would you have to duplicate the code? Also, why would changing something
on Day Shift necessitate changing it for Night Shift? What KINDS of things
are being changed?

You could use the "after update" event for either shift to set the field in
the other shift (which would make that record "Dirty", then just execute an
"If Me.Dirty then Me.Dirty = false" to post the other record. Watch out that
you don't keep firing the AfterUpdate events back-and-forth though, as theat
could get you into an infinite loop. You'll need to set a flag that tells the
OTHER AfterUpdate event NOT to fire again. Outside of that, it should be
pretty simple...

 

[Afrosheen via AccessMonster.com]

Thanks Dennis for the come back.
There are about 20-30 employees per shift. The data entry person uses a
roster from both shifts for information. That person then goes through each
record posting if they are working or not. When they get through with shift 1
being Day Shift staff, then they tab to shift 2 being Night Shift staff and
complete posting from the roster.

Why would you have to duplicate the code? Also, why would changing something
on Day Shift necessitate changing it for Night Shift? What KINDS of things
are being changed?

You could use the "after update" event for either shift to set the field in
the other shift (which would make that record "Dirty", then just execute an
"If Me.Dirty then Me.Dirty = false" to post the other record. Watch out that
you don't keep firing the AfterUpdate events back-and-forth though, as theat
could get you into an infinite loop. You'll need to set a flag that tells the
OTHER AfterUpdate event NOT to fire again. Outside of that, it should be
pretty simple...

First of all, thanks for reading this post.
I have one table with lots of fields in it. The field I'm concerned with this

[quoted text clipped - 14 lines]

Thanks again for reading this.

 

[Dennis]

Silly me, but why not have a single subform with the Main form having a set
of radio buttions with the values: "Day Shift" and "Night Shift"? The user
clicks the appropriate button on the Main form, which sets the filter for the
subform's data as well as setting the correct value (under the sheets) for
which shift. Seems like it would accomplish exactly the same thing but be
cleaner.

Thanks Dennis for the come back.
There are about 20-30 employees per shift. The data entry person uses a
roster from both shifts for information. That person then goes through each
record posting if they are working or not. When they get through with shift 1
being Day Shift staff, then they tab to shift 2 being Night Shift staff and
complete posting from the roster.

Why would you have to duplicate the code? Also, why would changing something
on Day Shift necessitate changing it for Night Shift? What KINDS of things
are being changed?

You could use the "after update" event for either shift to set the field in
the other shift (which would make that record "Dirty", then just execute an
"If Me.Dirty then Me.Dirty = false" to post the other record. Watch out that
you don't keep firing the AfterUpdate events back-and-forth though, as theat
could get you into an infinite loop. You'll need to set a flag that tells the
OTHER AfterUpdate event NOT to fire again. Outside of that, it should be
pretty simple...

First of all, thanks for reading this post.
I have one table with lots of fields in it. The field I'm concerned with this

[quoted text clipped - 14 lines]

Thanks again for reading this.

 

[Afrosheen via AccessMonster.com]

That may work. Thanks for the idea. I'll give it a shot.

Thanks

Silly me, but why not have a single subform with the Main form having a set
of radio buttions with the values: "Day Shift" and "Night Shift"? The user
clicks the appropriate button on the Main form, which sets the filter for the
subform's data as well as setting the correct value (under the sheets) for
which shift. Seems like it would accomplish exactly the same thing but be
cleaner.

Thanks Dennis for the come back.
There are about 20-30 employees per shift. The data entry person uses a

[quoted text clipped - 20 lines]

 

[tom_willpa]

high quality Soccer jerseys NBA Jersey tracksuit and jackets, GHD
hairstraightener supplier from www.willpa.com

Are you a Retail businessman who bother by the purchase price? China
Cheapest TOP wholesale website can help you

we are specialize in replica sport goods manufacturing in china, we can
offer you all kinds of soccer jersey, NBA jersey,shoes and so on. they are
the best brand replica goods whih are look the same as the original goods.
excellent quality and steady supply for them. we have been marketed in Europe
and American for 3 year. all the goods we offer are AAA quality. our soccer
jersey are Thailand style. If any goods you buy from my company have problem,
we will refund or resend them again. Most of ourProducts have no minimum
order requirements,soyou can shop retail goods at wholesale prices. if you
can buy more than 300usd. We offer free shipping. The more you buy the more
discount for you.

National soccer jerseys: http://www.willpa.com
Club soccer jerseys: http://www.willpa.com
NBA Jerseys: http://www.willpa.com
T-shirt and shirt: http://www.willpa.com
Tracksuit: http://www.willpa.com
Hoody & Jackets: http://www.willpa.com
UGG boots: http://www.willpa.com
Hair style: http://www.willpa.com
shopping Index: http://www.willpa.com

EMS shipping. 7days arrive, paypal accept

want more information pls contact us or check our website: www.willpa.com