Right, I've tried that, but I'm still getting a syntax error, saying that I've entered an operand without an operator.
= IIf( [Lesson] = 12 Hour , 12 , MsgBox("Please select lesson type") )
What I want to do is:
Enter value 12 into a box, should the lesson field = 12 hour, otherwise I want...