A
access_banker
I have a form that is used to select the reports to be previewed or
printed. There are a series of checkboxes one for each report. Each
report is a different listing of sub sections of information that is in
my main table. All of the information in the main table is listed by
SYS ID and the sub sections. Each report is printed or previewed based
check box for each sub section and a combo box for the SYS ID on the
Reports Selection form. What I would like to do is when the checkbox
is clicked validate against another table that the report has been
completed. A separate table is each to track status of the specific
systems and sub groups within the SYS ID. If the report is completed
then the check would be okay, if not then a message box would come up
to tell the person that sub section has not been completed and if
possible grey out the checkbox.
I have tried several avenues but I need some direction. Any help would
be greatly appreciated.
printed. There are a series of checkboxes one for each report. Each
report is a different listing of sub sections of information that is in
my main table. All of the information in the main table is listed by
SYS ID and the sub sections. Each report is printed or previewed based
check box for each sub section and a combo box for the SYS ID on the
Reports Selection form. What I would like to do is when the checkbox
is clicked validate against another table that the report has been
completed. A separate table is each to track status of the specific
systems and sub groups within the SYS ID. If the report is completed
then the check would be okay, if not then a message box would come up
to tell the person that sub section has not been completed and if
possible grey out the checkbox.
I have tried several avenues but I need some direction. Any help would
be greatly appreciated.