Can anyone help me assign the value of an SQL statement to a variable...

Here is what I have so far:


Code:
Dim strID As Recordset    
Set strID = New Recordset

strID.Source = "SELECT tblLIST_CS_EMP.ID " & _
                        "FROM tblLIST_CS_EMP WHERE tblLIST_CS_EMP.Full_Name = " & Me.cboName & ""
    
MsgBox strID.Source
The current output is the whole SQL statement with an equals sign and the coreect ID.

So, I am stuck on how to pull just the ID out of the recordset.