add to recordset error when no value

[Gina Maylone]

Good morning all! I am trying to update a recordset with the values chosen from a list box, it works slick, UNTIL Access runs across a null value in one of the columns, I'm trying to handle it with an IIF statement right now, to no avail, and I've tried using the NZ function with no luck.

rst!price = IIf([Forms]![Orders]![BuildItFloor].[Form]!LSTBUILDABLE.Column(5) > 0, [Forms]![Orders]![BuildItFloor].[Form]!LSTBUILDABLE.Column(5), 0)

How can I handle this? Thank you in advance!

[Minty]

Is the listbox on the form your code is on ?
Try setting the value into a variable first

Dim iValue as Long

iValue = Nz(Me.Lstbuildtable.Column(5),0)
rst!price = iValue

Alternatively if you build the list box row source from a query , use a Nz() in that to ensure there aren't any null values.