AlvaroCity
Registered User.
- Local time
- Today, 12:24
- Joined
- Jul 16, 2016
- Messages
- 70
hello everyone.
Working on my database I bumped into this problem
On my form I using some Dsum funtions to add some figures from the form, but when I'm going to introduce new data into the form, this fields are obviously empty and returns #ERROR and I would like to get rid of it.
I have been checking online and I saw the funtion "IsError" so I tried the next code. but this still returns #ERROR for some reason although when there is not error this surprisingly works fine. :banghead:
Working on my database I bumped into this problem
On my form I using some Dsum funtions to add some figures from the form, but when I'm going to introduce new data into the form, this fields are obviously empty and returns #ERROR and I would like to get rid of it.
I have been checking online and I saw the funtion "IsError" so I tried the next code. but this still returns #ERROR for some reason although when there is not error this surprisingly works fine. :banghead:
Code:
=IIf(IsError(FormatCurrency(DSum("TotalAlbaran","qrySubFactura","[FacturaID]=" & [FacturaID]))),"Blank",FormatCurrency(DSum("TotalAlbaran","qrySubFactura","[FacturaID]=" & [FacturaID])))