DAO Record Sets

[Michael Walker]

Hi

I am trying to set a record set as below but access dosnt recognise the DAO command. I am getting the error - Compile Error, User-defined type not defined -

Public Sub SpeedPoints()

Dim rsTable As DAO.Recordset
Dim db As DAO.Database
Dim TotalAmount As Single

Thanks

 

[Norie]

Make sure you have a reference to the DAO library under Tools>References...