Good Morning Guys,
What i am trying to do is a DCount on a table but instead of the criteria changing I want the column that is looks for the criteria to be variable based on a combo box
What I currently have is
=DCount("[Number]","[Products]","Cherry = True")
It is the column in red above that I wish to be based from the combo box drop down on my form which is combo1
If anyone can help it would be much appreciated, I'm still learning forms in access
Thank you
Regards