break vb code with a null field 1

[boiker]

i want my vb code to break and not run if a certain field is null.

currently the vb code compares an address to the name of a graphic file, if that file exists it loads that file. If the file does not exist, it loads a noimage.jpg file. I want the code to break if the address field is null and not load the noimage.jpg.

 

[Nancy2]

Do you really want it to break or just exit the sub and give an error message.

If FileName = "noimage.jpg" then
Msgbox "No file name.."
Exit Sub
End if

 

[Bussiom]

If IsNull(Me!your form field name)
will check if a field is null.
Mary