>>Hi,
>>
>>I'm using a basic loop to wait for new records to show up in a table. When a new record shows up, I process it and then wait for the next record to show up... sounds simple...
>>
>>But some records are slipping through un-detected. So of course, my totals are off. Interestingly, most (but not all) of the un-detected records are added by the same workstation.
>>
>>Any ideas why this might be happening? Any suggestions to improve this logic?
>>
>
>Why not add this table to a database and add an Insert trigger to the table?
>Then when a new record is added, the insert trigger automatically fires.

That's a darn good idea! And I will explore that option. But I'm still wondering why my code doesn't work :(

Thanks