I'm confused at this one.. annoying the heck out of me. I'm trying to get a bit of code to update an active x listview from a tree view. No matter what I do (and I've even borrowed some code) it won't open my query.. just keeps saying "Runtime-error" 13 Type mismatch. It highlights the "Set rs = db.OpenRecordset("qrytasks")" line everytime.
it even does it if I change the recordsource to something totally different.. same error
I've stripped it down to find the problem (i.e. just tried to get the query to populate the listview) but still getting the same problem
Can anyone suggest anything wrong with this code: Thanks in advance!
Dim db As Database, rs As Recordset
Dim intI As Integer, intTotalRecords As Integer
Dim colHeader As ColumnHeader
Dim lstItem As ListItem
Set db = CurrentDb
Set rs = db.OpenRecordset("qrytasks")