Quote Originally Posted by koolsid View Post
What is the value of rs!id

Check it manually by inserting this one line before...

Code:
Msgbox rs!id
If the value is correct then try

Trim(rs!id) before setting it as a value....
it is manually insert. when I use your code msg show: 1. and then show that msg. if i use trim(rs!id) not solve.