Error in text box when subform returns no values

[Guest]

I am receiving "error" in a number of text boxes that are used to calculate
figures based on 2 subforms. If the subform does not have any records all the
calculated text boxs return this error. I have tried using the nz function
and the ISNull function but i can not seem to get this to work.

=Nz((Claims.Form!sumClaimed),0)-Nz((Payments.Form!sumPaid),0)

Can anyone help me with this problem???

 

[Guest]

Try this

=IIf(Claims.Form.HasData, Nz(Claims.Form![sumClaimed],0),0) -
IIf(Payments.Form.HasData, Nz(Payments.Form![sumPaid],0),0)

 

[Guest]

Thanks for the response to this post, i tried the code below but this still
isnt working for me, i now receive #Name? in the text box. Any other
suggestions that might cause this to happen

Try this

=IIf(Claims.Form.HasData, Nz(Claims.Form![sumClaimed],0),0) -
IIf(Payments.Form.HasData, Nz(Payments.Form![sumPaid],0),0)

--
I hope that helped
Good luck

I am receiving "error" in a number of text boxes that are used to calculate
figures based on 2 subforms. If the subform does not have any records all the
calculated text boxs return this error. I have tried using the nz function
and the ISNull function but i can not seem to get this to work.

=Nz((Claims.Form!sumClaimed),0)-Nz((Payments.Form!sumPaid),0)

Can anyone help me with this problem???

 

[Guest]

Try this

=IIf(Claims.Form.RecordsetClone.RecordCount>0,Nz(Claims.Form![sumClaimed],0),0)
-
IIf(Payments.Form.RecordsetClone.RecordCount>0,Nz(Payments.Form![sumPaid],0),0)
--
I hope that helped
Good luck

Thanks for the response to this post, i tried the code below but this still
isnt working for me, i now receive #Name? in the text box. Any other
suggestions that might cause this to happen

Try this

=IIf(Claims.Form.HasData, Nz(Claims.Form![sumClaimed],0),0) -
IIf(Payments.Form.HasData, Nz(Payments.Form![sumPaid],0),0)

--
I hope that helped
Good luck

I am receiving "error" in a number of text boxes that are used to calculate
figures based on 2 subforms. If the subform does not have any records all the
calculated text boxs return this error. I have tried using the nz function
and the ISNull function but i can not seem to get this to work.

=Nz((Claims.Form!sumClaimed),0)-Nz((Payments.Form!sumPaid),0)

Can anyone help me with this problem???

 

[Guest]

Thanks alot ofer the code worked perfectly for me

Try this

=IIf(Claims.Form.RecordsetClone.RecordCount>0,Nz(Claims.Form![sumClaimed],0),0)
-
IIf(Payments.Form.RecordsetClone.RecordCount>0,Nz(Payments.Form![sumPaid],0),0)
--
I hope that helped
Good luck

Thanks for the response to this post, i tried the code below but this still
isnt working for me, i now receive #Name? in the text box. Any other
suggestions that might cause this to happen

Try this

=IIf(Claims.Form.HasData, Nz(Claims.Form![sumClaimed],0),0) -
IIf(Payments.Form.HasData, Nz(Payments.Form![sumPaid],0),0)

--
I hope that helped
Good luck


:

I am receiving "error" in a number of text boxes that are used to calculate
figures based on 2 subforms. If the subform does not have any records all the
calculated text boxs return this error. I have tried using the nz function
and the ISNull function but i can not seem to get this to work.

=Nz((Claims.Form!sumClaimed),0)-Nz((Payments.Form!sumPaid),0)

Can anyone help me with this problem???

 

[Guest]

Any time, good luck
--
I hope that helped
Good luck

Thanks alot ofer the code worked perfectly for me

Try this

=IIf(Claims.Form.RecordsetClone.RecordCount>0,Nz(Claims.Form![sumClaimed],0),0)
-
IIf(Payments.Form.RecordsetClone.RecordCount>0,Nz(Payments.Form![sumPaid],0),0)
--
I hope that helped
Good luck

Thanks for the response to this post, i tried the code below but this still
isnt working for me, i now receive #Name? in the text box. Any other
suggestions that might cause this to happen

:

Try this

=IIf(Claims.Form.HasData, Nz(Claims.Form![sumClaimed],0),0) -
IIf(Payments.Form.HasData, Nz(Payments.Form![sumPaid],0),0)

--
I hope that helped
Good luck


:

I am receiving "error" in a number of text boxes that are used to calculate
figures based on 2 subforms. If the subform does not have any records all the
calculated text boxs return this error. I have tried using the nz function
and the ISNull function but i can not seem to get this to work.

=Nz((Claims.Form!sumClaimed),0)-Nz((Payments.Form!sumPaid),0)

Can anyone help me with this problem???