Update combo boxes with separate form

[Guest]

I have a form with several combo boxes. If a certain choice is chosen
(example: Yes in control for rodent infestation) then a form opens that locks
everything until a supervisor enters a password ensuring that they were
notified. Now they want the options to be farther apart so that Yes isn't
accidentally chosen. I haven't found any way to do this. Any ideas? I am
using combo's to save room. I thought about opening another form with
command buttons, but can't figure out how to reference the control that
opened the form since I would be using the same form for each combo. Please
help!

 

[Guest]

If I read you correctly it seems like the real problem is accidental
locking.....and the suggestion to make the options "farther apart" is maybe
one way to prevent it....

I think a dialog/message box is probably the traditional approach...if they
select 'Yes' then have a message box appear with some sort of message to
double check they really mean it....and then have the result of that box
determine whether form locks or not....

 

[Guest]

Thanks for answering! I did suggest this approach, however my manager is
concerned that when they realize that they will lock the database with their
choice that they will just change it. I know.........they will eventually
come to this conclusion anyway, but he's the boss!

 

[Guest]

though you are space constrained ; you could make the Rodent control a
checkbox or radio button.....as the act of checking it is far less probable
to be accidental than a pulldown combobox.....and then you can put the
locking on the OnChange event of the control....

 

[Guest]

Thanks! I'll try that and see what he thinks!