Need help on update query in Access

Hi,
I am trying to update a table in access when a user makes changes to the list
of names and press a button.
However, I would like the event in the button to grab the value from the
textbox and run the query below.

DoCmd.RunSql "Update dbo_job_test.wellname where Wellname = " " &

So after this I don't know what to write. If someone has a clue, please help
me. Please provide me with a sample if possible.
Thanks a bunch.
Christine


--
Message posted via http://www.accessmonster.com
.