Type Mismatch? 1

[Kib]

what am I doing wrong here?
Private Sub Form_Load()
Dim db As Database
Dim rs As Recordset
Set db = CurrentDb
Set rs = db.OpenRecordset("myrates&quot
End Sub

 

[kathryn]

What version of Access are you using? if it is A2K, then you have to specify dao.datbase and dao.recordset, I think. Kathryn

 

[Kib]

Thanks!
Did the trick

 

[dowally]

Access may be asking what type of recordset you are trying to open, for instance, dbOpenTable. Not sure, just a thought.