Error when form opens

[Elphaba31]

Hello Gurus,

I have been tasked with correcting issues with our upgrade and essentially know very little about Access 2007 or Visual Basic. Here is my current issue: when we open one of our .accdb it throws this error:

"Compile error: Method or data not found"

(see attached jpeg)

Can anyone pass on some pointers of how to fix this? A good tutorial would be nice, I'm learning Access 2007 & VB by troubleshooting these errors, so it's peice by peice.

THANK YOU in advance for your assistance!!

 

[MStef]

For "Rs.FindFirst.....
in OpenRecordset put ... dbOpenDynaset instead of dbOpenSnapshot.

 

[Elphaba31]

First, THANK YOU for the fast reply!

Ok I changed dbOpenSnapshot to dbOpenDynaset and changed RS.FindFirst to RS.Find (just changing Snapshot to Dynaset didn't work), now I still get the same error but it highlights RS.NoMatch....

 

[CEH]

In your code editor click "Tools"... "References" see if anything says "missing"

 

[SOS]

I would change your recordset declaration to

Dim RS As DAO.Recordset

because it might be thinking it is looking for an ADO recordset instead.