Set rs = CurrentDb.OpenRecordset("PricingSelling", dbOpenTable)
which appears to be a crash of some description. The only difference between my setup and the example is the table i'm trying to open is a linked table and the table exists as a sharepoint list
To investigate further i made a local table copy of the sharepoint list linked table and i don't get this error, so i'm guessing opening a table as a recordset doesn't work with linked sharepoint lists
apologies for drip feeding information as i didn't know there would be an issue with where the table resided/whether the table was linked or local
With the local table though i get the next error:
So this goes back to an understanding about what the following line does:
.Index = "srch_index"
@arnelgp any pointers/ideas would be gratefully received