If checkbox checked display message...

[mvital]

Hi!

I've looked everywhere and I can't find what I need. I know it is simple I just don't know the syntax. I am fairly new with VBA, but getting better.

I have a form with a checkbox (not option group). If the checkboxed is checked I want a message to display to the user that they have to fill out a quantity.

I also don't want the user to leave the form with out filling out the quantity.

thanks in advance!

 

[Hafa1961]

You could try:

Private Sub NameOfCheckbox_AfterUpdate()

If Me.Checkbox = True Then
MsgBox "You need to fill out the quantity"
Me.Quantity.SetFocus

Exit Sub
End If


End Sub

 

[mvital]

Thank You Hafa1961. Worked great!