Issue with reference and Nz

[Guest]

Here is the record source I had for the field "Tank Total" and it worked
GREAT until I moved the subform into another form

=IIf(zzzTankBasics_History.Form.RecordsetClone.RecordCount=0,0,Nz(zzzTankBasics_History.Form!Location_Overall_Total,0))

Originally zzzTankBasics_History was a subform within TankBasics. The code
worked. The field "Tank Total" has always been in the TankBasics form and it
still is.

Now zzzTankBasics_History is
Form -> Subform -> Subform
TankBasics -> zzzTankBasics -> zzzTankBasics_History

I tried adding zzzTankBasics in front of the zzzTankBasics_History for
=IIf(zzzTankBasics_History.Form.RecordsetClone.RecordCount=0,0,Nz(zzzTankBasics_History.Form!Location_Overall_Total,0))

but I get an #Name? in the field

Any help is appreciated.

Can

 

[ruralguy via AccessMonster.com]

Try:
zzzTankBasics.Form.zzzTankBasics_History.Form.RecordsetClone.RecordCount

 

[Guest]

Thanks, works great!

Try:
zzzTankBasics.Form.zzzTankBasics_History.Form.RecordsetClone.RecordCount


--
HTH - RuralGuy (RG for short) acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via AccessMonster.com

 

[ruralguy via AccessMonster.com]

Great! Thanks for posting back with your success.

Thanks, works great!

Try:
zzzTankBasics.Form.zzzTankBasics_History.Form.RecordsetClone.RecordCount

[quoted text clipped - 20 lines]