Check Boxes

  • Thread starter Thread starter NEC-2008
  • Start date Start date
N

NEC-2008

I have a form with 6 check boxes. Lets call them A B C D E & F.
In the normal course of events, you would select one of the A B C D or E and
move on.
What i'm after is, if you select F without selecting one of A B C D or E to
accompany it, this would generate a message box that would say "Please select
process type
(which would be one of the A B C D or E) before proceeding."

How do I wright the code for this and where do I place it. (i.e. Before
update, Got Focus, ect.)

Thanks for the help.
 
NEC-2008 said:
I have a form with 6 check boxes. Lets call them A B C D E & F.
In the normal course of events, you would select one of the A B C D or E
and
move on.
What i'm after is, if you select F without selecting one of A B C D or E
to
accompany it, this would generate a message box that would say "Please
select
process type
(which would be one of the A B C D or E) before proceeding."

How do I wright the code for this and where do I place it. (i.e. Before
update, Got Focus, ect.)

Thanks for the help.
Click to expand...

Put the following code in F's AfterUpdate event procedure:

Select Case False
Case A, B, C, D, E
MsgBox "Please select process type before proceeding."
Case Else
End Select
 
Thanks for the reply. When I tried this it worked but it kicks it out because
I have some hypphened words. Let me work it a bit and I'll get back to you.
 
Back
Top