Help With Record Source And Recordset

I have a form with a record source already defined (used so the user can browse through records and edit them)
I have the form store requirement ids and not the name however I would like to present the requirement name rather then the id to the user
So it tried with a sql query and a recordset but I keep getting the error data type mismatch in criteria expression on this line
Set rsm = dbm.OpenRecordset(sRequirementName1)

I think the problem is having the record source already defined and then having a new Recordset not sure how to work around it

here is the code
----------------------------------------------------------------------------------------------------------------------------------------------------------
Private Sub Next_Click()

Dim sRequirementName1 As String
Dim queryResult As String
Dim wsm As workspace
Dim dbm As Database
Dim rsm As Recordset

sRequirementName1 = "SELECT Requirements.RequirementName " & _
"FROM Requirements " & _
"WHERE Requirements.RequirementID = '" & Me.RequirementID11.value & "' "


Set wsm = DBEngine.Workspaces(0)
Set dbm = wsm.OpenDatabase("E:Practicum Hours.mdb")
Set rsm = dbm.OpenRecordset(sRequirementName1)

queryResult = rsm.Fields(0)

Me.HoursCompleted11_Label.Caption = queryResult


End Sub

----------------------------------------------------------------------------------------------------------------------------------------------------------

I have also attached the DB if anyone thinks they can help, if you are confused about what i am trying to do with the modify form i made one with students that works
it is the modify hours1 form and the code above is the on click event for the next button

Thanks for any help anyone might offer