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


B

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
 
Ad

Advertisements

J

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top