#error by missing related record

  • Thread starter Thread starter Gaston Loos
  • Start date Start date
G

Gaston Loos

I have a table and a query related (1-many). When there is
no related record, there should be just the table, and not
the related records from the query (they must give null).
But instead of null the field is 'filled' with anerror.
The error can't be captured wit an expression like
isError, IsEmpty, IsMissing, IsNull.

first question
Why does the error appear and not a null-value

second question
How can I handle the error (case-error-then-null solution)
 
Back
Top