Hi,

I'm trying to update an unbound form fields back into the table using a recordset.

I'm having troubles with Null values.

Here's the code:

rst!Field1= nz(me.field1,Null)

- However, this seems to fail no matter what I put for the nz null value.

The only thing that seems to work is pretty clumsy:

If Nz(Me.Field1, "") = "" Then
rst!Field1 = Null
Else
rst!Field1 = Me.Field1
End If

Any other suggestions?

Thanks,