Ok, new guy here..

[VBAWTB]

I am trying to extract data from a field in a table to a variable so I can use it in a comparison within VBA. But I am getting a type mismatch error and I can't for the life of me see where the mismatch is... here is the code..

Dim dbsSubwayDB As Database
Dim rstSnapShot As Recordset

Set dbsSubwayDB = CurrentDb
Set rstSnapShot = dbsSubwayDB.OpenRecordset("tblSettings")

WkEndngDay = rstSnapShot!weekendingday

...the red is the line the error is on... weekendingday is the field in the tblSettings table..Help!

 

[boblarson]

Change

Dim dbsSubwayDB As Database
Dim rstSnapShot As Recordset

to

Dim dbsSubwayDB As DAO.Database
Dim rstSnapShot As DAO.Recordset

 

[VBAWTB]

Thanks! That was it! And thanks for the very fast reply =]