Making Label visible based on checkbox

[bigrush]

Firstly I am very new to this. I am developing a driving safety checklist database for some co-workers and myself. So far I have one table that includes a few text boxes to get information like name, date, business purpose etc. Then I have a few checkboxes, DUSK, DAWN, RAIN, SNOW ETC. Based on whether some of these boxes are checked, I want to be able to have a label displayed. There will be 3 labels totaled, MINIMAL RISK, MEDIUM RISK, HIGH RISK. So for example if I fill out the form and if I have DUSK and RAIN checked, then the HIGH RISK label is visible and the othe r 2 labels are not etc. Please help.

[NeoPa]

As your question is expressed very generally and with no details, my answer must be the same. This is unfortunate, but I can't respond to something you haven't shared.

In the module of your form you need a procedure which encapulates the logic that you presumably know. This will set the .Visible property of the label depending on which checkboxes are set.

This procedure needs to be called from the Form_Current() event procedure, as well as the AfterUpdate() event procedures of all the checkboxes included in the logic.

[bigrush]

Thanks I appreciate your response.