When the result of the search is true, the form is not refreshing.
>Assuming that you were just checking if the entered value allready exist in the table, you would want to pass .F. to the lMovePointer parameter.
>
>I dont understand your second paragraph. What do you mean by that?
>
>>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.
He is there and He is not Silent.