Expression and restricting events / Line brake in MsgBox

  • Thread starter Thread starter Peter
  • Start date Start date
P

Peter

Hi all!...i have this issue. In a forms “after update†event I use the
following expression:

1. I receive error message “optional argumentâ€
2. How do I restrict the form to close (this is what happens after update)
when the below runs…i.o the result of this expression is further action..to
choose other then “Bagâ€
3. How do I insert a line brake in a MsgBox..


If (Me.Bag = "Apples") And IIf (Me.Days = IsNull > 30) Then
Me.Days.SetFocus
MsgBox "Bla..bla bla "
End If

Thanks for a assistance!..should above been devided into three separate
questions?
 
Correction!!. I now realize this should result in three questions. Please
disregard this question. I will post three separate.

Sorry for the incontinence, Thanks!
 
Back
Top