Check Boxes

[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.

 

[Stuart McCall]

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.

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

 

[NEC-2008]

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.