Insert

**mike60smart** · 08-06-2021, 12:53 PM

Hi Everyone

I am trying to carry out an On Click Event to insert a number of records into another Table.

This line is giving me an error:-

Code:

80    lngManufactured = Me.Manufactured

The error message I get is this:-

How would I modify this line to deal with Null Values ?

Any help appreciated.

**Gicu** · 08-06-2021, 12:55 PM

Maybe try

Code:

lngManufactured = Nz(Me.Manufactured,0)

Cheers,

**mike60smart** · 08-06-2021, 01:59 PM

Hi Vlad

That fixed that just great
Thanks

**Gicu** · 08-06-2021, 08:41 PM