By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,551 Members | 2,741 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,551 IT Pros & Developers. It's quick & easy.

Making Label visible based on checkbox

P: 2
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.
Mar 11 '12 #1
Share this Question
Share on Google+
2 Replies

Expert Mod 15k+
P: 31,494
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.
Mar 11 '12 #2

P: 2
Thanks I appreciate your response.
Mar 11 '12 #3

Post your reply

Sign in to post your reply or Sign up for a free account.