Breakpoint in VBA code

[wchelly]

And where CountOfMyMVField_Value is greater than 1 it has more than one selection.

bIsMultiValue = (rs(0).Type > 1)

Are you talking about this part of the code?



I assumed that I should build the below fields into my query... and not into the VBA, Is that right?

SELECT Table1.MyID, Count(Table1.MyMVField.Value) AS CountOfMyMVField_Value
FROM Table1
GROUP BY Table1.MyID;