I am using (as we were talking about it before) a CHR(13) as an end of the string. In this case I only have one entry per scan in the table.

>If commevent <> 2, you have no input to collect. This would insure you are only doing your INSERTs when there is new data.
>
>Do these rows in any way look like your scan? With my change, are you still getting 22 rows?
>
>>But what if commevent <> 2? How will my form's property collect .input?
>>Data all the same in all 22 rows.