I'm getting an error with 2nd last line of code (dCurrentAssets = CDbl(sCurrentAssets))? Have been struggling for a few hours so getting desperate...
Thanks in advancePlease Login or Register to view this content.
I'm getting an error with 2nd last line of code (dCurrentAssets = CDbl(sCurrentAssets))? Have been struggling for a few hours so getting desperate...
Thanks in advancePlease Login or Register to view this content.
When it errors, what is the value of sCurrentAssets?
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
sCurrentAssets = ""
Try changing that line to
or possiblyPlease Login or Register to view this content.
Please Login or Register to view this content.
Thanks for your reply - much appreciated! I changed to "AfterUpdate" & it works. I will try your suggestion & revert once tested.
Probably because sCurrentAssets is null?
Sorry didn't see the above.
Last edited by Croweater; 05-26-2020 at 10:01 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks