Invalid Use of Null - Access 2013 VBA -

i have loop goes through using ado collect information 1 table populate another.

when record 11096 run time error. "run-time error 94: invalid use of null"

this whats highlighted

invdate = dateserial(rstde![year], rstde![month], rstde![date]) ' coverts year, month, , day, date format. 

if hover on it reveal "7/19/2015", why thinks it's null?

o opened table rstde refers , went record 11096, looks fine. contains exact same number , format records above it.

this solved.

there must have been skipping of lines in original table causing me see wrong information when checking myself why throwing null error.

just added check before date function"

if not isnull(rstde![year])   invdate = dateserial(rstde![year], rstde![month], rstde![date]) ' coverts year, month, , day, date format.   rstar![invoiced date] = invdate   rstar![outstanding days] = (date - invdate) end if