I have managed to write some vb to write data from one table to another. However, it seems to stop with a message (Run time error ’94’ Invalid use of Null).
This specifically occurs at the point
strVariable= ![Field]
Is there away I can put a statement in to avoid the nulls. If I use an if statement in the form…
If Field=null then…. It doesn’t seem to work and carries over the value anyway.
Any suggestions please.
This specifically occurs at the point
strVariable= ![Field]
Is there away I can put a statement in to avoid the nulls. If I use an if statement in the form…
If Field=null then…. It doesn’t seem to work and carries over the value anyway.
Any suggestions please.