Retrieving Value from database table using Database and RecordSet

[zzzqqq]

Hi,
Anyone know how to retrieve the actual table value after these steps? New to vb and finding it difficult to figure this out?

Dim dbs As Database
Dim rst As Recordset
Dim strSQL As String
Dim strRequestNo As String
Dim retVal
Dim checker As Integer
Dim ReqNo, stDocName As String
Dim stLinkCriteria As String
Dim imvProject As String

Set dbs = CurrentDb
Set rst = dbs.OpenRecordset("tblFisSection", dbOpenDynaset)

strSQL = "Select ivmProject from tblFISSection where RequestNo =" & RequestNo
Set rst = dbs.OpenRecordset(strSQL)

Any idea how I retrieve the ivmProject value?
Mark.

 

[Ed2020]

imvProject = rst!ivmProject

Ed Metcalfe.

Please do not feed the trolls.....

 

[TheAceMan1]

how are ya zzzqqq . . .

[blue]   rst("ivmProject")[/blue]

or if [blue]ivmProject[/blue] resides in a variable:

[blue]   rst([purple][b]VariableName[/b][/purple])[/blue]

See Ya! . . . . . .