Nz Function (?)

[an]

Hi!

I have a mainform with a subform.
The subform is based in Q_SO.
The Q_SO has >=20 in Age column.
The same subform has another a textbox to show us age number.
Work fine and only show data if Age >=20.

The mainform has a textbox to show age number too.
But this textbox if don't show data in subform because Age<20, show #Error.

How is possible to resolve this, please.
Tnahks in advance.
an

 

[Allen Browne]

You may be able to solve the problem with an expression like this:
=IIf([Sub1].[Form].RecordsetClone.RecordCount = 0, Null,
[Sub1].[Form]![Text0])

Access 2007 will not be able to understand that expression, so it won't work
in the new version.

In earlier versions, that will solve the problem is it is caused by the
detail section going completely blank because there are no records to
display, not even the new record row.