Run-time error '3315' 1

[thirty4d]

Hello!

I have a form where I have to extract different values to create an assembly.

I have extracted 3 records so far and everything seemed to be working fine. I have followed the same steps through out.

When I came to the 4th record something went hay wire because I keep getting this error:

Run-time error '3315'

Field 'Form.Fieldname' can't be a zero-length string.

Thanks if you can help me

 

[Databaseguy]

You'll have to add error handling to check for a null value. Use the vbNull constant to check for it. If you find it, out something, anything, into the 'Form.Fieldname' so you don't get the error.

 

[thirty4d]

Databaseguy,

Thank You! fixed the error