DB/Reporting :: Conversion Issue Access 2003 To 2007

I converted one of my databases from 2003 to 2007 and am getting the following error 13 type mismatch with 2007 (did not happen with 2003 version) with the following code:

Thanks for your help!


HTML Code:
Private Sub PageFooterSection_Print(Cancel As Integer, PrintCount As Integer)

Dim strMessage As String

Dim db As Database
Dim rs As Recordset

Set db = CurrentDb
[B]Set rs = db.OpenRecordset("TblFooter")[/B] ERROR HIGHLIGHTS THIS LINE

'--- Grab Recordset Values.
strMessage = rs!PageFooter



'--- Place text onto the form Labels.
test.Caption = strMessage



rs.Close
db.Close
Set rs = Nothing
Set db = Nothing

End Sub