Cross checking on the controls

[croby]

Hi, On my form I have a Current status field and a Resolution date field. If the Current status contains a value “Closed”, then the Resolution date field should not be empty.
I want to use the following coding:

If (Me![cboCurrent].text= “Closed”) And IsNull(Me![txtRdate) Then
MsgBox "You must enter a Resolution date for a closed case!"

Is the above coding correct? In which Event I should put the cross checking codes?

Any help will be appreciated. Chris

 

[Rich]

On the Form before update event
If (Me![cboCurrent].text= “Closed”) And IsNull(Me![txtRdate) Then
Cancel =True
MsgBox "You must enter a Resolution date for a closed case!"