get a record and update that record
Posted on 2013-02-04
I am having a serious mental block. I need to retrieve a record from my DB based on a query
dim rs as adodb.recordset
dim sSQL as string
set rs = new.adodb.recorset
sSQL = "Select balance from ctbal" & " where ctbalID = " & Me.txtID
when I debug print this I get:
Select balance from ctbal where ctbalID = 1
if the field in question "Balance" has a value say 2 then why does my code say "empty" when I place my cursor over the field.
Here is exactly what I am trying do accomplish:
1) Extract the field value of "balance" from my table CTbal.
2) Add to the field from my form to create a "new" balance
3) Update my table to reflect the "new" balance