>>Requery are not suitable, i am working in multiuser environment
>
>Why is requery a problem in a multiuser environment?

Requery retrieved all the data again... let said 2 user add new invoice at the same time, i dont want the first user to search for his invoice no# which is a identity field