I've got an unbound textbox in a form with a dcount expression in it as the control source.
The result I want is a count if 2 different yes/no fields are both ticked.
The control source expression is as follows, but it keeps giving an error message in the textbox. Also, the textbox flashes (like it is stuck in a loop).
As you might guess, I'm a bit new to this (I've been looking on the net, but can't find a similar example to guide me).
field1 is text, field2 and filed3 are logical (yes/no) fields
Hope you can help.
=DCount("[field1]","table1","[field2]=True and [field3]=True")