I'm not sure how to describe this.....

[Guest]

Here's what I've got:

My database is used to track a group of systems and schedule them for
service by week per month. I have a form that is called weekly schedules.
When you click on the button, another form opens with buttons for week
1-week4 (representing the weeks of a month). When you click on the desired
week, a list of systems and locations are displayed in a report.

What I need:

When I click on the desired week, I would like a prompt to ask if I want a
specific system to be scheduled that week. Is there something that I can do
to have a prompt come up after selecting the week just for the few systems
that may or may not need to be scheduled that week? I'm picturing that there
would be something in the table that the record comes from that 'marks' it so
that there is a prompt when the desired service week is selected, for that
system, on the form to verify that it will need to be serviced.

Thanks for any tips or advice that can be given!

 

[Guest]

Can't you just add a field to your table called SvcWeek or similar and enter
1 to 4 to represent the week?

TonyT..

 

[Guest]

I actually have that...I should have explained that part better.....The
problem comes about because I have some customers that even though they have
a '1' in the svc week box, they may not need service that month, so I need
the option to exclude them from the report.

 

[Guest]

In which case, if you add a listbox to the form, press button week1 and then
populate list with customers due to be serviced that week, then let the user
select which ones in the list to include or exclude (whichever is likely to
be least) and run a code to create a query based on the Selected property of
the list to be used as the data source for the report.

TonyT..