troubleshooting Question

Getting error "Object variable or with variable not set" in ADP DAO procedure.

Avatar of tomllewis
tomllewis asked on
Microsoft Access
7 Comments1 Solution661 ViewsLast Modified:
O.K. my brain is about to explode.  I have the following code in an Access ADP (2003):
Private Sub cboSelectTag_AfterUpdate()
    Dim db As DAO.Database
    Dim rs As DAO.Recordset
   
    Set db = CurrentDb
    Set rs = db.OpenRecordset("Select * From Taglines", dbOpenDynaset, 512)
    If Not rs.EOF Then
    Me.txtStoryPoint = rs(0)
    End If
End Sub

I get an error - Object variable or Block with variable not set.  The recordset is trying to adderss a SQL Server 2005 table with an identity field. I have a reference set for Microsoft DAO 3.6 Object Library.
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 7 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 7 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros