var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Count Listbox Values on a Continuous Form
I have a form that is set to view as "continuous" or a list of records.
One of my fields is a list box with 3 values, Reserved, Wait List, Cancelled.
At the bottom of my form I want to be about to count the total number of Reserved Records.
I am trying to creat a text box with the control source as "=count([status].Itemdata(0))" but that gives an error
"status" is the name of my list box field and 0 is my "Reserved" value
try using count(iif(listbox = "reserved", 1, 0))