Set value in macro

[Matt]

I have a form that lists all rooms for a specific customer. For each room
there is 5 checkboxes (Stage 1,2,3,4,5). The checkboxes are checked in order
of 1,2,3,4,5 as each stage is completed. After the checkboxes are checked
the user clicks on a command button that takes them to another form that
lists all of the materials ordered for that room. Each product has a field
called WIP (this is a combo box with 5 values: WIP 1, WIP 2, WIP 3, WIP 4,
WIP 5). There is also another check box called Deplete for each product.

I'm trying to create a macro that will do the following:
If Stage 1 is checked in the Room form every product with the value of
WIP 1 will have its Deplete checkbox checked automatically.
If Stage 2 is checked in the Room form every product with the value of
WIP 2 will have its Deplete checkbox checked automatically.
The same is true for the other Stages.

Thank you in advance for your help

 

[DevalilaJohn]

It sounds like you need an update query that will do the change. Along with
that you want the query to get criteria from either the check box to apply
against the combo to identify the stage.