Check field value and generate message

[PascalZ]

I would like to generate a message popup based on the value in a field:

If the value of a combo box is set to "6.Closed" a message saying "Check Date Closed" should appear.

Any help is welkom.

Pascal.

 

[SydneyGeek]

Let's say the combo is called cmbStatus. Create a text box called Warning, with the message that you want.
Format it red and bold, flush with the form surface, no border, and set Visible to No. Move the text box to the desired location on the form. [Translation: you want the BackColor and Border properties to be the same as for a Label].

The following code needs to go in the Form_Current and cmbStatus_AfterUpdate events:

If [cmbStatus]="6.Closed" Then
  [Warning].Visible=True
Else
  [Warning].Visible=False
End If

Now, the message will appear when the combo has the desired value

Denis