>thanks for the reply eric, i've tried using a textbox and linking it directly to the field to be updated. however, a new problem arose, whenever i try to update more than 3 records, without using the "refresh" command, an error occurs stating that "too many rows were affected by the update", why is this so? and what is the best remedy, sorry for bothering you again, and thanks!
What is your LockType (I hope that it is different from BatchOptimistic).
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com