DSUMS & DCOUNTS - #Error Message

[DanSc0tt]

When I am using Dsums / Dcounts etc I sometimes get a #error in my textbox, sometimes it can be a format thing, but alot of the time it just corrects itself - any ideas what could be causing it?? as it is quite irritating

TIA

Dan

 

[rori666]

Although its impossible to say for sure, I would check your criteria expression. I recieved those type of errors when no record matched the desired criteria.

 

[zatch]

Sometimes when you add functions to your text boxes like DSum, you have to change the name of the text box. Go into the 'other' tab of the textbox properies and slightly change the 'name' of the text box.