that was perfect robbedaya.

another question if you dont mind.
i see you put adOpendynamic, adLockPessimistic.
is adOpenKeyset, adLockOptimistic correct for just showing the data and yours for updating it ? and why have you put "Top 1" in the statement ?

thanks for your help.