the data of one field trigers the data of another

Silvera · 11 Mar 2014

In MS Access how do I have one field's data trigger another data?
I've tried this but no result:

Private Sub rfi_closed_BeforeUpdate()
If rfi_dt_to_contr = "NULL" Then
rfi_closed = "NO"
Else
rfi_closed = "YES"
End If
End Sub

If "rfi_dt_to_contr" is empty I want the field "rfi_closed" to be "NO" and if there is data [i.e. a date] it is to be "YES".

GEWB · 11 Mar 2014

Hmm, it's been a while but as I recall NULL is not the same as EMPTY.

Regards,
GEWB

Ranger4 · 11 Mar 2014

This MS website may help you as there is a list of the various types of field data information requests. Refer to the list down the left hand side to check for other types.

IsNull Function