Hi Charles Use the slap.lastrecordread property to check end of select rather that key <> "". You could run into funny issues including type mismatches that could fall over.
Also aren't you meant to look in field 3 not field 2 of the key for 000. If you are new to VB, it is worth considering your design. With Client server, it is important to keep the business logic close to the database and not with the client. The client should be more for display logic. If you keep the business logic in subroutines in Uv, then you can reuse the business logic for web pages, web services and other applications. Regards David Jordan ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/