Making Yes/No Fields Execute Different Filters or Functions

[RichardAnderson]

Howdy Folks,

It's the newbie back with another question. You guys have been helpful so far.

Background Changing

I have a form named frmBuilds_All. This is a continuous form and has 4 yes/no fields. They are "WaitingFab", "WaitingPaint", "WaitingParts", and "Completed". The labels however are just "Fab", "Paint", "Parts", and "Completed". I would like to make it so that when one of these check boxes are checked, the label for that box has it's background color change.

Filter From List



On a separate form named fromBuilds_Today, a list of all builds for today are displayed. I would like to make it so that when the check box for "Completed" is checked, the record in question is filtered off of this list.

Are either of these things possible?
Keep in mind though that I know very very little about Access and VBA. I can follow instructions fine and learn well by doing real world examples.

[June7]

Is frmBuilds_All in datasheet or continuous view? If so, can't do this.

Why do you have 4 yes/no fields? Can all of these fields be Yes at the same time? Maybe just need one field with 4 option values.

One filter method: parameter in query under the Completed field: =0
use code to requery the form when the checkbox is clicked

[RichardAnderson]

Is frmBuilds_All in datasheet or continuous view? If so, can't do this.

Why do you have 4 yes/no fields? Can all of these fields be Yes at the same time? Maybe just need one field with 4 option values.

The 4 yes/no fields are for a purpose..

WaitingFab is checked if that job is waiting on the fabrication shop
WaitingPaint means the job is waiting on the powder painters.
WaitingParts means we are waiting on parts on P/Os to be received.
Completed is ... well... completed. the job is built.

To make these checkboxes changes the labels BG color would visually make it stand out when looking at the continuous form list.

One filter method: parameter in query under the Completed field: =0
use code to requery the form when the checkbox is clicked

Would this only requery and update the list on the computer that clicked the checkbox?

If so... Is it possible to set 2 filters on the same form?
1) Only records that match Date()
2) Exclude any records that have Completed marked Yes.

This would make the page be updated when the requery timer runs on the other computers.

[June7]

Didn't really answer my question. Can all checkboxes be checked at the same time? Would it be confusing if multiple checkboxes checked? Nothing prevents that. Consider a single field and change the value as the job status changes.

When the field edit is committed to table the changed value is available for review by all users. Forms refresh periodically (every 60 seconds is application default).

Queries, forms, reports can have multiple filter criteria.