empty field to variable

  • Thread starter Thread starter Jean-Paul
  • Start date Start date
J

Jean-Paul

Hi,
in my code I have now:
contact = [Forms]![verslagen].[Sub_Bedrijsgegevens].[Form].[Contactpersoon]

Of course I first wrote dim contact as string.

Now:
[Forms]![verslagen].[Sub_Bedrijsgegevens].[Form].[Contactpersoon]
is empty, so I get an errormessage when the code reaches this line
saying something like:
illegal use of Null

How to avoid this and let the code continue even if it meets a null-field

Thanks
 
Back
Top