#type! / #error

[britesynth]

Good Day!

I'm having a little issue with my form

I have a form with a subform and I want to display the count of the record displayed on my subform (source is from a query which I filter using a combo - criteria is [cbo] or Is Null - so I can filter or display all record as I need)


I placed a text box on my subform/datasheet footer
=Count([txtCountClientID])

then

I tried placing a text box in my main using this source
=IIf(IsNull([subfrmGroupTag].[Form]![txtCountClientID]),"no clients to display",[subfrmGroupTag].[Form]![txtCountClientID])

the false part is working fine - displays the count
the problem occurs when there is no record in the subform - displays #ERROR or #TYPE!

tried Nz on my footer didn't work either - I think it returns #TYPE! for my true part

how will it return 0 when my query/subform has nothing to display?

anything I'm missing?

thank you in advance!
-jake

 

[Galaxiom]

Use IsError() instead of IsNull()

 

[britesynth]

Use IsError() instead of IsNull()

sir galaxiom thank you, it worked!

may I know how and why it works?

is it because of my subform?

 

[RuralGuy]

I'm thinking you were getting the error because there was no record yet. It was not null!

 

[britesynth]

I'm thinking you were getting the error because there was no record yet. It was not null!

Good Day Sir Allan =)

there are 7 records in my test database,

I think I have to rephrase this

"I tried placing a text box in my main using this source
=IIf(IsNull([subfrmGroupTag].[Form]![txtCountClientID]),"no clients to display",[subfrmGroupTag].[Form]![txtCountClientID])

the false part is working fine - displays the count
the problem occurs when there is no record DISPLAYED in the subform - displays #ERROR or #TYPE!"

I want to know how such errors can occur

thanks! =)

 

[RuralGuy]

Just use Galaxiom's solution.