I have a form containing a combo box. The control source is a SELECT statement, grabbing values from a table field called Users. The combo box works well. The combo box is a multivalue lookup field. It has check boxes next to each value. Checking the boxes for different user names, puts those names in a paragraph, which I can see without dropping the list of values. This is all working OK. I drop the list of names, check the boxes and when I exit the combo box, the names I selected show in a paragraph.
If I check only 2 or 3 names, no problem, I can take a look and quickly count. Sometimes there are dozens of names being displayed and I have to stop and count them all by hand if I want to know the count of names...
My question is, how can I count how many boxes have been checked (how many user names are being displayed in this Lookup Field/Combo Box)?
Is there any way to get a calculated total?
Thanks.
If I check only 2 or 3 names, no problem, I can take a look and quickly count. Sometimes there are dozens of names being displayed and I have to stop and count them all by hand if I want to know the count of names...
My question is, how can I count how many boxes have been checked (how many user names are being displayed in this Lookup Field/Combo Box)?
Is there any way to get a calculated total?
Thanks.