Continous form problem

  • Thread starter Thread starter Cathy
  • Start date Start date
C

Cathy

I need to create a form/subform that attaches to a
calendar. The form/subform has a list of the users daily
todos based on the date they picked from the calendar and
their ID. The thing that sets this calendar apart from
the norm is that the users is supposed to click a checkbox
when they've completed an item. This logs the users ID
and date/time in a table. (Up to this point, I have
everything working fine.) Next, if their supervisor is
supposed to review the item, there should be a check box
for them. And if the manager needs to review the item,
there should be a check box for them. The problem I'm
having is making the checkboxes for the supervisor and
manager appear only on rows where the supervisor and/or
manager need to approve/review an item.

So far I've tried coding the supervisor & manager's check
boxes to be visible/invisible. But, from what I
understand, this will not work on a continuous form. A
subform will not work on a continous form either... What
other opportunities do I have? My boss really wants this
to look like a 'report' of todo items with check boxes
visible or not visible based on whether or not they are
needed. Having a user check off the items individually
defeats the purpose of putting them in a database.

Thanks in advance for any help you can provide.
Cathy
 
I am not 100% clear on how the items are selected that require the
attention of the supervisor and, maybe, manager.
You are right - you can't hide checkboxes on a continuous form. You can,
however, filter the continuous (sub)form to show only those items
requiring the attention of the supervisor and, maybe, manager by putting
check boxes on the main form (or radio buttons).
I think that it is not the hiding of the check boxes that you can do in
this case - it is hiding of the entire records that are not needed.

Pavel
 
Back
Top