Find exact Match

[Guest]

Hi

I have a code which uses findfirst too check if a number currently exists
however it is advising that the number I am checking does exists but when I
check in the table it is not there.

ie looking for 356 but is finding 356125

Thanks
Noemi

 

[John W. Vinson]

Hi

I have a code which uses findfirst too check if a number currently exists
however it is advising that the number I am checking does exists but when I
check in the table it is not there.

ie looking for 356 but is finding 356125

Thanks
Noemi

Please post your code. It's rather hard to fix an error without seeing the
code!

John W. Vinson [MVP]

 

[Marshall Barton]

I have a code which uses findfirst too check if a number currently exists
however it is advising that the number I am checking does exists but when I
check in the table it is not there.

ie looking for 356 but is finding 356125

Use = instead of Like in the FindFirst criteria.