Invalid Use of Null Error: Please Help!

[2e1fmo]

AddOwner !OwnerCode, !HolidaySector, !BookingReference, !ClassKey, !sitecode, !payment, !area, !forename, !surname, !address

I am trying to call the function Addowner and taking across field values from a table. How ever the problem is that some field have no value, thus bringing up an the invalid use of null error on this statement.

Any ideas of how I could resolve this error?

many thanks in advance

 

[Alexandre]

Either use the Nz function (see Access Help) or a variant type (less efficient).

Alex