Textbox Error

[bigfigkid]

Hi Everyone !
Happy Holidays ...

I have an access form which has in particular a textbox and subform. The subform is comprised from a query, and the textbox references a field in the subform.

Everything works fine, until at which time I have no results in the subform, and the textbox gives me #Error.

I have tried inserting code in the parent forms onActivate event, testing if the subform isnull, and isempty, but to no avail. Maybe I'm going about this the wrong way, but I'm looking for some input on how to handle this.

Thanks much ...

 

[TheAceMan1]

How are ya bigfigkid . . . . .

Is the [blue]Textbox[/blue] on the main or subform?

Post the [blue]ControlSource[/blue] for the textbox.

See Ya! . . . . . .

 

[bigfigkid]

textbox is on main form.

=[qryTRANSFER subform].Form!SumOfWALLEYETRANSFER

 

[TheAceMan1]

bigfigkid . . . . .

In the [purple]ControlSource[/purple] try:

[blue]=Nz([qryTRANSFER subform].Form!SumOfWALLEYETRANSFER, 0)
[purple][b]or[/b][/purple]
=Nz([qryTRANSFER subform].Form!SumOfWALLEYETRANSFER, "")[/blue]

See Ya! . . . . . .

 

[bigfigkid]

for some reason the nz function still yields an #Error.

This error only happens when the field I reference in the subform contains no records. The subform is derived from a query.