Can anyone help me assign the value of an SQL statement to a variable...
Here is what I have so far:
The current output is the whole SQL statement with an equals sign and the coreect ID.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
So, I am stuck on how to pull just the ID out of the recordset.
