Can't find update query

[dkc]

Below is a custom function. I am looking for the query that is referenced here, "qryUpdateVendIDList". I need to change the odbc that it is looking at. I can't find this query in order to make the change. Besides, the obvious, looking at the database queries, which I have done, and UpdateVendIDList is not listed as the query, where can I find this query so that I can modify it?? (access 2003)

Thanks

Deb Chard
ILX Lightwave

Function UpdateVendorIDList()
On Error GoTo ERR_Handler
'Update Vendor ID List
DoCmd.SetWarnings (0)
DoCmd.RunSQL ("Delete * from VendorIDTable")
DoCmd.OpenQuery ("qryUpdateVendIDList")
DoCmd.SetWarnings (1)

MsgBox ("Vendor ID List Updated")

ERR_Handler_Done:
Exit Function
ERR_Handler:
Call WriteErrLog("isOpen", Err.Description)

Resume ERR_Handler_Done

End Function

 

[Remou]

Have you checked that it is not hidden? Does it exist in the MSysObjects table?

 

[dkc]

Yes, that was it, the query was hidden, I found it and was able to change the ODBC connection and all is well.

Thanks for your help

Deb