Thanks Sylvain I'll use it next, it sounds much more efficient especially on large tables. I assume to use this the lMovePointer must be used to go to the record.
BTW the form doesn't seem to be responding to the command at all if a current number is placed in the txtBox. Do you know why the lostfocus event being true is not firing this correctly? I think this may be at the core of my problems.
Thanks
>Replace the Seek() in your code by IndexSeek(). IndexSeek() does the same thing as Seek(), except that it won't move the pointer in the table.
>
>HTH
>
>>Yes the controls are bound to the Man table by dragging them from the DE to the form. If the pointer is being moved to the end of the table and disabling the txtBoxes what code do I use that will reset the pointer to the top of the table and will that reenable the boxes after a refresh?
He is there and He is not Silent.