run time error "2427" expression has no value

[mgio]

Getting this error when my subform should be returning a blank value so that the user can input against the subform to create new entries. If tried numerous fixes and haven't found any, Does anyone maybe know a workaround? like a way to ignore the error and proceed? Any Help is greatly appreciated

[azhar2006]

See the name of the subform and make sure it has a good Maybe you copied to another subform new form

[John_G]

If you want to ignore the error, look for the routine where the error occurs, then trap the error with On error Go to ....

In the error handler part of your code, you could do something like this:

If Err.Number = 2427 then
Exit Sub
Else
' display error message
endif

That does not really "ignore" the error, but nothing happens in the event that it occurs.

HTH

John