Prev: Plz...Help
Next: Outlook 2007 Access 2007
From: babs on 5 Apr 2010 09:51
I have a main form with each employees info - name address cell etc.
the subform shows each week End(ie 52 records per year)- what they are
scheduled to do for EACH week.

When i filter the Subform for a GIVEN week end it would like it to HOLD for
when I navigate to the Next employee to see what THEY are scheduled for that
given weekend but Now when I navigate on the main form to the next employee
it shows ALL week End(52 records) just want to see for now That given
weekend?? Don't want to have to refilter for each employee??? do I add a
command button not best at code not sure what to do here

what am I missing??
thanks,
barb

From: John W. Vinson on 5 Apr 2010 12:09
On Mon, 5 Apr 2010 06:51:01 -0700, babs <babs(a)discussions.microsoft.com>
wrote:

>I have a main form with each employees info - name address cell etc.
>the subform shows each week End(ie 52 records per year)- what they are
>scheduled to do for EACH week.
>
>When i filter the Subform for a GIVEN week end it would like it to HOLD for
>when I navigate to the Next employee to see what THEY are scheduled for that
>given weekend but Now when I navigate on the main form to the next employee
>it shows ALL week End(52 records) just want to see for now That given
>weekend?? Don't want to have to refilter for each employee??? do I add a
>command button not best at code not sure what to do here
>
>what am I missing??
>thanks,
>barb

Sounds like you need to base the subform, not directly on the table, but on a
Query selecting just the current (or desired) week's data. How is the "week"
stored in your table - as a date? a week number? What's the current filter and
how do you set it?
--

John W. Vinson [MVP]
 | 
Pages: 1
Prev: Plz...Help
Next: Outlook 2007 Access 2007