Should I Use Bound Or Unbound Controls ?

Hello !
i am new to databases so i would be grateful for your help.
I am using SQL Server 2000 and vb to access and update the records of a database.

I want your opinion about the way i am displaying data.
I have created a form with textboxes etc. which display the fields
of the table.
Now when i load the form i populate a recordset with a
"select ... from... " query.

Then i manually
set

txtfield1.text=cstr(recordset.fields("field1").value)

etc...

If i want to update the table then i have to construct manually the
query.

"update ... set field1='"+ txtfield.text +"' "

if i want to move to a next record i do

recordset.movenext
and then
txtfield1.text=cstr(recordset.fields("field1").value)

again
Is that good or should i use bound controls ?

If multiple users access the same form at the same time (from different computers) will they be locked only when they save (update) data ?

Thank you !