Checking Subform Value on Command Button not working

[jazzy]

when i stop the code it shows me that the [subfrm_Invoice].[Form]![InvoiceCreatedDate] = Null. When i remove the if then statement i can put the current date value in that field. sure its a different way i have to specify the field. Thanks

Private Sub OpenDepositInvoice_Click()If [subfrm_Invoice].[Form]![InvoiceCreatedDate] = Null Then
[subfrm_Invoice].[Form]![InvoiceCreatedDate] = Date
End If
End Sub

[kd2017]

Try IsNull() https://learn.microsoft.com/en-us/of...snull-function

If IsNull([subfrm_Invoice].[Form]![InvoiceCreatedDate]) Then
    [subfrm_Invoice].[Form]![InvoiceCreatedDate] = Date
End If

If that doesn't work. Are you more directly referring to a form's control or record source's field? if your referring to a control you may try to test if it's equal to "" (an empty string) rather than compare against null. (untested guess... worth testing though)

Either way bookmark this handy reference http://access.mvps.org/access/forms/frm0031.htm

[CJ_London]

nothing = null, not even null

use the isnull function

If isnull([subfrm_Invoice].[Form]![InvoiceCreatedDate]) Then

or the nz function


If nz([subfrm_Invoice].[Form]![InvoiceCreatedDate],0) = 0 Then

[June7]

In Access/VBA, can't compare anything to Null because there's nothing to compare.
Handle Null as described by CJ.

[jazzy]

That was it, thank you