Recordset run type error 13

[Bill]

Hi,

My Code is as follows:-

Dim dbMyDB As DAO.Database
Dim rsMyRS As Recordset
Dim fldMyfield As Field, lngRecCount As Long
Dim ingInitial As Long

Set dbMyDB = CurrentDb
Set rsMyRS = dbMyDB.OpenRecordset("Holidays")

when I get to last line I get a run time error.

Can you help me what is wrong with my code.

Thanks

Bill

 

[Ken Snell [MVP]]

Likely you have both ADO and DAO libraries set as references in your
database. Disambiguate the Dim .. Recordset line:

Dim rsMyRS As DAO.Recordset