Testing empty combo box

C

Chris Kennedy

I have a bound combo box which when you go to a new record is blank as it is
bound it is filled in on other record. When the new record on the form is
filled in I need to ensure something has been selected on the combo box. The
code I use is

If IsNull(Forms!frmInscriptions.cboCemetery.Value) = True Then
intvalidate = intvalidate + 1
strValidate = strValidate & " a cemetery "
End If

or also

If IsNull(Forms!frmInscriptions.cboCemetery.Value) Then
intvalidate = intvalidate + 1
strValidate = strValidate & " a cemetery "
End If

it doesn't return an empty value. Does anyone have any ideas? Regards,
Chris.
 
Top