Alert message pops up when check box is clicked on in a form

[junglej815]

Hello,

I have a form in Access that has has a drop down menu that is populated by a table and there is also a check box on the form as well.

I was hoping to see if there is a way to make it so that when the drop down box has a particular item chosen and when the check box is clicked an alert message pops up with a specific message.

Hope this isn't too vague.

Thanks.

[SamT]

Here's a vague answer.


Private Sub CheckBox1_Change()
If CB1.Value = False Then Exit Sub

Select Case DropDown1.Value
Case "X"
MsgBox "X is not Allowed
Case "Y"
MsgBox "Y is too small"
End Select
End Sub











'

[junglej815]

Hey Thanks for replying. Let me see if I can get more detailed.

I have a table set up in Access that has numerous items in it - the table is named CRAFT.
On my form I have a ComboBox which the control source is that table named CRAFT.
I have a checkbox on my form that I click to show that the form/assignment is complete.
What I would like to know is.... if a particular item, say 522 MOVE INSPECTION, is dispaying in the combobox and if I select the check box so say that it is complete, then a message box pops up with a particular message in it.