filter on subform looking at Week End date/prob navigate on main f

[babs]

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

 

[John W. Vinson]

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?